PowerApps - Delete specific items and then patch new set of records

(0) Share

Report

Posted on by SanjayAdsure201

Dear All,

I'm building a SharePoint List form based PowerApps. One of the operation is I need to delete specific list items and then patch new set of records right after that.

I'm doing it like below:

With(
{
wRecords:
Filter(
SPListName,
customID = DataCardValue31.Text
)
},
RemoveIf(
SPListName,
ID in wRecords.ID
)
);

Patch(SPListName,
UpdateIf(GlobalCollectionName,
Created=Blank(),
{ID:Blank()}
)
);

My issue is, sometimes it works but sometimes it just mixes records and before deleting all records goes patching records so final output is wrong. I want the program to wait till it finishes deleting the items and then only patch new set of records.

Could you please help. Any help will be appreciated.

Thanks,

Sanjay

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
HI @SanjayAdsure201 , Can you try this code and check the behavior:
ClearCollect(col_Records, Filter(SPListName, customID = DataCardValue31.Text ) ); ForAll(col_Records As var, Remove( SPListName, LookUp(SPListName, ID= var.ID) ) )
Then rest code for patch will remain same.
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB