Delete data in SharePoint list based on excel file in SP

(1) Share

Report

Posted on by Jawaharprem

286

Hi all,

i built a flow to delete data in SharePoint list, based on id's given in SP document, the flow ran successfully but the data has not deleted in SP List in updated the flow for reference

Thanks

Jawahar Prem

Categories:

Building flows

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Jawaharprem

The issue is in the Get items > Filter Query.

Unique_ID eq 'Unique_ID'

It should use the Unique_ID value from the Excel file row.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
SpongYe Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my blog [@S pongYe] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(1)

Report
Copy link

Link copied!
If your Power Automate flow shows “Succeeded” but the SharePoint list items are not actually deleted, the issue is usually related to one of the following:

incorrect ID mapping,

Excel values being treated as text,

wrong SharePoint item ID,

filter/query mismatch,

or the Delete Item action not receiving the correct item ID.

My Strong Recommendation

Use:

int(items('Apply_to_each')?['ID'])

before Delete Item.

This resolves a large percentage of Excel-to-SharePoint deletion issues in Power Automate.

Was this reply helpful? Yes No
Suggested answer

Jawaharprem 286 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks i works i added item()?['Unique_iD'] it working fine

Was this reply helpful? Yes No
Suggested answer

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Jawaharprem,

Please consider marking my answer as the solution so it can help others with the same issue.

Tthanks for confirming. item()?['Unique_iD'] works because it pulls the actual Unique_iD value from the current Excel row inside the Apply to each loop, instead of comparing the SharePoint column to a fixed text value.

Glad it’s working now.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
SpongYe Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my blog [@S pongYe] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Ellis Karim 12,163 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Jawaharprem,

Check also that the Excel 'List rows present in a table action has a pagination threshold set to a suitable limit. See:

Power Automate: How to Read More Than 256 Rows from an Excel Table

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No