Power Automate - Flow to Add Update Delete items from Excel to SharePoint - Part 02 - Detailed Look

It's often useful to be able to synchronize Excel items with a SharePoint list. Here we take the modern Power Automate experience to Add and Update items from Excel to SharePoint and Delete any items in SharePoint that are no longer needed.

For access to resources supporting this and other videos consider joining us on Patreon;

[jampeauk]

Really hope you get the last video of this up soon, I have watched this now 3 times and I still cannot get my version of this flow to work.

[Jay-mhxh]

This was exactly what I was looking for!!!! Thank you so much!

[silverwhite]

Great video waiting for part 3, thank you

[allybartz]

Hi Jamie, thank you for the video. For my compose and parse JSON actions with SharePointkeys, I am getting the error "Invalid Type. Expected string but got Null." I have various columsn that, depending on the scenario, may have no data in the column. Is there a workaround for this?

[carloshumbertocallejalopez]

This video is great! Do you have any plans to release part 3?

[crsolutions]

Hi Jamie, i am new to all this, but i have created a create new / update flow to take data from SQL Table to Sharepoint list, and have a unique SQL ID for each row.. I am looking some guidance on carrying out the delete function in relation to the record being deleted in SQL and ensuring this is removed from Sharepoint on a recurring basis. Any tips on the flow steps would be really appreciated. Thanks

[jayo]

If I want to update a sharepoint item using the response from a form how would I go about this? Love the content btw!

[arthurnami]

very nice and good explanation. When to expect part 3, this for clarification for the compose and parse functionality as this is not clear in how to do that in the video

[sarikamageshbabu]

Hello, My flow is creating duplicates, I don't know how to fix it

[sininv]

Do I need the Initialize variable? as mine is picking from SP

[junwang]

Hi, Jamie, Thank you for this nice video! One question about Table_query at 3:00, why I don't have that choice?

[louielat]

Awesome video! How easy do you think it would be to include dates too? We’d like to populate one of the columns with dates too

[rozzumar]

Thanks. I've got most of the way through but I'm struggling with the create item at the end. I don't get the options you have with the alarm clock symbol next to the field names. Please can you release part 3? I have contributed to your patreon.

[stormywilliams]

Thanks for the great video/content!! I'm so close to getting this to work but it looks like I'm missing a step - At 8:44 mark where you have the condition creating an Item, it's labeled "Create Item 2" I don't see anywhere that you used this function/Action before this point, so I'm guessing that's why I'm having issues. Is this something you are saving for your Patreon members? or am I just missing something altogether? Thanks in advance!

[lissy]

Is it possible to use this function to create several Sharepoint lists from one excel sheet? All of the lists would have the same columns.

[Violenceinsilence]

I managed to successfully create this flow. The only catch is in the last step (Create Item) at 8:33, you need to enter manual values instead of choosing from the dynamic builder. The manual value will look something like this

[kamacete]

First of all, a very nice video. However, I tried to replicate your steps and I cannot save because of an error.
"The template validation failed: 'The inputs of template action 'Compose_DestinationDocs' at line '1 and column '4273' is invalid. Action 'Apply_to_each_MainDoc' must be a parent 'foreach' scope of action 'Compose_DestinationDocs' to be referenced by 'repeatItems' or 'items' functions.'."
could you please help me?

[sininv]

I need to update daily without any recurrence is it possible anytime any user to update or delete in excel & update to SP list . Can I just put manual trigger instead recurrence. Thx

[kturnbeaugh]

How do you do this when the "Title" is a number? I have a form that
people fill out and it includes their ID number, I then have an Excel
Spreadsheet that I want Microsoft Flow to look at and pull their email,
department, title from and put into the Sharepoint list. The ID number
is a number, which seems to confuse Sharepoint Online and Flow, or at
least I can't get it to work.

[vjnvinod]

Awesome video, but i am getting some error,

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Condition_2' at line '1 and column '10985' is invalid. Action must be a parent 'foreach' scope of action 'Condition_2' to be referenced by 'repeatItems' or 'items' functions.'.'.