Answered

Delete rows in Excel and get same rows deleted in SharePoint list via Power Automate

Like (1) Share

Report

Posted on 10 Aug 2022 12:37:41 by Community Power Pla...

Hello community,

I have an Excel file and make changes only at this file. When I modify the excel file, I have already a corresponding SharePoint list which is successfully updated, i.e. when a row is changed or added in Excel.

However, I am lost about which flow I need to build for the following: Delete a row in excel and then also delete it in SharePoint list.

My flow so far is the following:

In the Update Item and Create Item section, I match all the SharePoint columns to the Excel columns.

I hope my problem is explained clearly enough.

Thank you very much for any help!

I have the same question (0)

All responses (4)

Answers (1)

Slowpoke 157 on 10 Aug 2022 at 13:18:34

Like (0)

Report

Re: Delete rows in Excel and get same rows deleted in SharePoint list via Power Automate

Hi,

Maybe you could first "get the line" on excel that you want to delete,

Then delete it in your Excel file, using "delete line"

Then, you could use "sharepoint get item" with an odata filter using dynamic content from the "excel get line", to get the item with a corresponding title/id.

And finally, use the "sharepoint delete item".

Does it seem a good solution for you?

Was this reply helpful? Yes No
Community Power Pla... on 11 Aug 2022 at 13:12:29

Like (1)

Report

Re: Delete rows in Excel and get same rows deleted in SharePoint list via Power Automate

Hi,

I am not sure I really got your solution tbh. I tried to do the following but I am pretty sure there is a mistake in the least condition because I get all items deleted in the SP list.

Any ideas how I can test if the array values match the corresponding column values in SP?

Thanks a lot for any help!

Best,

Ilona

Was this reply helpful? Yes No
Slowpoke 157 on 11 Aug 2022 at 13:19:37

Like (0)

Report

Re: Delete rows in Excel and get same rows deleted in SharePoint list via Power Automate

I remember that using "Column Name" eq something doesn't really work, (especially with excel connectors).

I'd advised you to use substringof() instead (cf. OData Filter query in SharePoint Get items in Flow (sharepains.com).

As well, maybe use "contains not" in the condition, so that if it's not working it won't delete anything.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on 15 Aug 2022 at 12:12:58

Like (0)

Report

Re: Delete rows in Excel and get same rows deleted in SharePoint list via Power Automate

So, I found a solution to anyone interested.

Corrections from the previous sscreentshot:
1. I removed the Filter Query in "Get items" because this way, the output was only the matching values between SP and Excel, whereas I need all the values from Excel to compare with SP and delete afterwards.
2. I used Compose because I couldn't compare the array variable to an Excel column. I used the following function: string(items('SPitem')?['Title']), where SPitem is an 'apply to each' action and Title in the column with unique identifiers in SP list.

Hope this helps!

Was this reply helpful? Yes No