How to Send Excel Table Data to a SharePoint List Using Power Automate | 2022 Tutorial

Hi Everyone,
In this video, I demonstrate how to send an Excel data table to a SharePoint list using Power Automate. This is an easy to copy data over. When the data is in a SharePoint list, it can be utilized with multiple Power Automate actions.
If you enjoy my content feel free to like, comment, and subscribe!
#powerautomate #powerapps #microsoftflow

[@nathaliesaint-marc5180]

Hi Michael, Many thanks for this very useful video. For some reasons my SharePoint list has duplicate lines. My table has 827 rows and SharePoint list has 1083. Do you have any idea why this would happen? I used the instant cloud flow at the beginning. Many thanks.

[@insinhala7014]

Thanks!

[@adamilafamilychannel]

Hi Michael , If the excel data will updated every week (such as inventory) , can you advice for skip if the data already exits in sharepoint list?

[@mogahidsabeel4988]

Greate video Michael, well done. can this flow serve to update sharepoint list as well as adding data (No need to uodate items action)? using Recurrence trigger to update if there is any changes in the excel table or add new data if new raws added to the excel table?

[@nomandanishshaikh9174]

Hey Michael, Your content is fantastic, and I've gained valuable insights from your videos! By the way, could you explain how to enforce data validation for all columns in the 'Parse JSON' action, making all the columns in excel required?

[@michaelalex2322]

You could try forcing data validation, but you would likely run into errors if a data value is blank. I usually set my 'Parse JSON' to strings and include null as well

[@sejala4266]

After going through many videos got confused and finally reached here....thankyou so much this was one video which helped me. can you do a video on how to update and add Excel data to sharepoint using power automate? there's no beginner friendly video on this topic.

[@rajwaran6497]

Hello Michael, I'm also looking to do this and I'm having trouble. Let us know. Thanks

[@vaishaliparmar2440]

Can you please tell me why you used Parse JSON here??

[@Dmoneyfit]

is it possible to create a new folder in SharePoint with files copied from another SharePoint location using info we input into a Excel table data set?

[@eslamfahmy87]

I think the jason action is more complicated. Do you have alternative, also could you share with us the schedule triggers also

[@michajozefowicz5689]

Hej Michael, good video thanks! One question: does the flow update the list when for example the value is updated in Excel or if the row is deleted there? I need to have solution when the user is able to update the excel and it's reflected in the list.

[@michaelalex2322]

No the flow won't do it. If you want the SharePoint List to update to the Excel sheet you could run a scheduled flow at midnight daily. Would show fresh data for the day

[@michajozefowicz5689]

@@michaelalex2322 thanks for a quick reply. Does it mean that if I set up the flow as a scheduled in the step #1 and keep the rest as you showed it would update the list based on my Excel sheet? I need to get to the state where when users delete/change some values in Excel it also deletes/updates SharePoint list accordingly.

[@moisestatis5418]

Hi @@michaelalex2322 do you have a video on this recommendation? thanks

[@dhiravtm464]

Hi how did you get it to work?

[@user-oy6zf8uw7p]

Is it possible to take an individual sheet from excel and copy to a sharepoint? Or does it need to be more detailed?

[@michaelalex2322]

It needs to be in a table and not a sheet

[@faisalomari7111]

Dear Michael, I have a data in excel which has 914 rows and 200 columns, it is a simple contract management sheet. I wanted to import to to sharepoint list using power automate flow, i also faced same error as this: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_1' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'. What is your advise on this pls..how should i fix it?

[@damolaojoniyi5307]

Some data in the column is not consistent Check if any of the column consist the columns in the row are empty ? If some are empty change ur type in the parse json to {type : Number, string, interger, null}

[@carolinejusten384]

Dear Michael, any chance to only get the new data into the list by deleting/overwriting the old data? I want to update the list daily to make sure we are using the latest data.

[@michaelalex2322]

You can either remove all the items in the SharePoint List and then add each item in the Flow. Or if you have a unique ID in the Excel you can filter the SharePoint List and update that row. If the item isn't in the list then create it. The second one is harder to create in Power Automate depending on your experience.

[@bilalshaikh2917]

Why do we have to parse json, When I tried direct excel values to sharepoint it worked.

[@michaelalex2322]

If it works that way, then the parse JSON isn't needed.

[@high5457]

can't it be stored as dd-mm-yyyy format alone i don't want the timing

[@kayne3619]

Did you ever do a video on this? 2:27?

[@cdfoodiereviewchannel8936]

Does the flow kick off every time a item is uploaded in to document library?

[@michaelalex2322]

No, this doesn't. You have to specify the Excel file in the document library.

[@gerardorivera7228]

Do you know how many rows this flow copies?

[@gerardorivera7228]

Because my excel has more than 4,000

[@michaelalex2322]

Should be able to handle 4000 rows. You will need to go into the Settings of the action and set the Pagination to 5000

[@udaykrishna882]

Is there any limit to transfer ? I have 20k records in excel but after list rows in the json i can see only 257 records??

[@michaelalex2322]

Are all the records contained in a table? Also, turn on Pagination in the List Rows to a number greater than your records

[@udaykrishna882]

@@michaelalex2322 can you help me with suggestion : is it good to maintain sharepoint list as datasource for power apps where data expected is 10Million records ??