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.

I have the same question (0)

All responses (4)

Answers (0)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Add and Delete your SharePoint List from Excel Table data

@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

Was this reply helpful? Yes No
Lorem1960 379 on at

Like (0)

Report

Re: Add and Delete your SharePoint List from Excel Table data

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.

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

Re: Add and Delete your SharePoint List from Excel Table data

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.

Was this reply helpful? Yes No
Lorem1960 379 on at

Like (0)

Report

Re: Add and Delete your SharePoint List from Excel Table data

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.

Was this reply helpful? Yes No