Dataverse Gallery UpdateIf not working

(0) Share

Report

Posted on by abc3

207

Dont know why it not work

UpdateIf(Table, Seq>ThisItem.Seq &&Id= ThisItem.Id, {
 Seq:Seq-1
 });

And I had trying to do

UpdateIf(Table, Seq>ThisItem.Seq &&, {
 Seq:Seq-1
 });

It work except same id item not update

Using the Same filter to Set a table can find the value i need

Even I hardcode all value it still not work

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @abc3 ,

Could you please share more details about your scenario? What control and where are you applying this formula to bulk update the table?

Best regards,
abc3 207 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-jefferni I have a SalesLine Table on dataverse. User will scan the barcode to enter data it will auto save it on the dataverse when user wrong product input they delete it and the Seq of the number will auto update.But the when i click the delete Icon onselect the UpdateIf not working. And i was trying to the same thing using the collection it work perfectly fine. I am sure the filtering was not wrong because i was using the same filtering and same icon to save the data on the collection. It can show all i want, and i have built the same scenario using collection it work fine but when i change it back to the dataverse it not work again. I know using patch and same filter can do the update but i want to know why updateif not working

UpdateIf(Table, Seq>ThisItem.Seq &&Id= ThisItem.Id, { Seq:Seq-1 });//Not Work ClearCollect( A, Filter(Table, Seq>ThisItem.Seq&& Id= ThisItem.Id) ); //Work fine Set(Test,Filter(Table, Seq>ThisItem.Seq&& Id= ThisItem.Id));// Also Work fine on same onSelect
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @abc3 ,

Generally, it should work. Could you please share the process of saving and deleting wrong input in Dataverse table? Formulas as well as screenshots of UI will help a lot.

Best regards,