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!

✨Support My Channel✨

If you enjoy my content and would like to support my work, consider buying me a coffee! Your support helps me create more videos and keep the channel going. ☕💖

🪙BTC🪙: 3LpmcBaJB537RweJu2tRjSqT6NhnQDDBWy
⛓️ETH⛓️: 0xbAEb6d6Df7CE5cfC55797B3133342e165B78A444
🐕DOGE🐕: DNKNUduorzBWMJ4XTSRqUSsUKk3ZiehHin

#powerautomate #powerapps #microsoftflow

[sejala]

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.

[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?

[mogahidsabeel]

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?

[nomandanishshaikh]

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?

[nathaliesaint-marc]

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.

[kayne]

Did you ever do a video on this?

2:27?

[eslamfahmy]

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

[bilalshaikh]

Why do we have to parse json,

When I tried direct excel values to sharepoint it worked.

[vaishaliparmar]

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?

[carolinejusten]

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.

[oyzfuwp]

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

[michajozefowicz]

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.

[high]

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

[faisalomari]

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?

[cdfoodiereviewchannel]

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

[udaykrishna]

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??

[gerardorivera]

Do you know how many rows this flow copies?