Add and Delete your SharePoint List from Excel Table data

(0) Share

Report

Posted on by Lorem1960

379

I am a new user of power automate and I am looking for a power automate flow can do the following:

1. Reads data from an Excel table and then only add rows to a SharePoint list when these rows do not yet exist in my SP list.

2. Delete rows from my SP list when items are no longer listed in the Excel workbook but are still listed in the SP list.

Would be very much interested in seeing some example flows that can handle this scenario.

Thank you very much.

Categories:

Building flows

All responses (4)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Lorem1960 Do you want to sync excel rows with SharePoint List items in both direction? Please confirm so that i can give you detailed solution.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Lorem1960 379 on at

Like
a
(0)

Report
Copy link

Link copied!

No basically want I want to accomplish is to compare a SharePoint List with an Excel table and then delete any items from the SP list that do not appear in the Excel table, in addition, Create items in my SharePoint list when new items are listed within the workbook.
v-LilyW-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lorem1960
Here is a great video tutorial, Please click the link to see if it is helpful enough.
https://www.youtube.com/watch?v=aNoPNcXIg08
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lorem1960 379 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes I tried using the same flow but the issue I am having is the following:

In my SharePoint list I have 3 columns that are used by our users to enter tracking information, so the moment I rerun the flow that tracking information is being removed? I guess because the flow is actually recreating the rows that are coming from the excel table.