PowerFX Remove() doesn't remove all items from collection - Model Driven App - Button

(0) Share

Report

Posted on by DanielBurian

Dear all, I have crafted a new button "Remove All" on Quote form (D365 Sales - Model Driven App) using PowerFX Command.

It works quite well, but recently I was surprised to see that not all the records are deleted.

The command is:

If(Confirm ("Are you sure?",{ Title: "Remove All Quote Products ?", Subtitle: "This action will remove all products from the quote", ConfirmButton: "Yes", CancelButton: "No" }), Remove('Quote Products', Self.Selected.Item.'Quote Products',RemoveFlags.All);Refresh('Quote Products'))

I use the RemoveFlags.All ... which is as per documentation - isteadof deleting 1 reocrd, it deletes all records.

The problem is that success is not 100%. Sometimes I need to press the button twice to have all the Quote Products deleted. It looks to me as implementation bug.

Any other thought - suggestion ?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

SoPatt Microsoft Employee on at

Like (0)

Report

It deletes all records that match your record exactly. If you want to remove all records from a collection, Use Clear('Quote Products') or if you want to remove all records that match a filter, use RemoveIf().

Was this reply helpful? Yes No
DanielBurian 6 on at

Like (0)

Report

Thank you. It shouldn't however ... since I refer to a collection of the Quote Products as part of the Quote (which the form is at) ... Self.Selected.Item.'Quote Products' ... so there are no "matches" involved ... .

And it works ... 95% .. it deletes all the products ... like 10 or 15 ... but sometimes if fails and 1 or 2 products are not deleted. So I press button seond time and rest is gone.

I will test the Clear and let you know.

Was this reply helpful? Yes No
DanielBurian 6 on at

Like (0)

Report

Clear is unfortunately not currently supported in model-driven apps.

Use Power Fx with commands - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
SoPatt Microsoft Employee on at

Like (0)

Report

RemoveIf('Quote Products',true)

Was this reply helpful? Yes No
DanielBurian 6 on at

Like (0)

Report

Tested. Unfortunately, it doesn't do any better. Even worse, while the previous command was always refreshing the Opportunity Products grid correctly, this RemoveIf takes a lot longer and refresh is not fast or even not coming at all.

Was this reply helpful? Yes No