Data not getting deleting from excel to SharePoint list

(1) Share

Report

Posted on by Jawaharprem

286

Hi All,

i created a flow to delete data from SharePoint, there is column in SP as Unique_ID i uploaded that ID's in excel and converted to table format and uploaded in SP Doc total there are 900 numbers the first 505 has been deleted the balance numbers are not deleting i was trying form last week that blance numbers are not deleting and i tried giving 3 numbers also data is not deleted , but it get success after 3 mins, need your inputs how to clear this issues.

Thanks

Jawahar R

Categories:

Building flows

Using connectors

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@Jawaharprem,

List rows present in a table → Settings Pagination = ON set the threshold value to 5000 (or 10000).

Filter Query

If Unique_ID is Text column Unique_ID eq '@{items('Apply_to_each')?['Unique_ID']}'

If Unique_ID is Number column Unique_ID eq @{items('Apply_to_each')?['Unique_ID']}

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Jawaharprem 286 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi MS.Ragavendar,

Thanks for your time, done as per your settings given but not deleting, in filter i give the expression what u given for text i just added the pagination.

Was this reply helpful? Yes No
MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Jawaharprem,

Even after the tweaks the items are not getting deleted ?

May i know why you have used the excel we can directly delete the items from the sharepoint list right ? Why Excel and Comparing and Deleting ?

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jawaharprem,

Can you please add a retry and delay to handle transient throttling? To be very specific add 1-5 secs between bathcess or retries to reduce throttling. This thread can help you.

Was this reply helpful? Yes No
Suggested answer

Jawaharprem 286 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

now it works i created index on unique_id on list settings and it deleted, thanks for support.

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Jawaharprem,

Glad that it worked please close the thread so that it will be helpful for the community team who will face the similar issue in the future.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No