Power Automate - Flow to Add Update Delete items from Excel to SharePoint - Part 01 - Explainer

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;

[alejandrasalgado]

Thank you so much Sir to Share your knowledge❤

[luuminhvuong]

How about the reverse...sharepoint to excel!

[resrudeboy]

Do you have any suggestions on importing the date fields in excel to the share point list?

[luisfalsiroli]

Advanced options is not available anymore under the conditions tab! How should I paste the function you typed under advanced options?

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

[AnkitaSharma-nnti]

Will it work for an excel containing 10K + records ?

[beenasharma]

Will it work for an excel containing 10K + records ?