Unanswered

Fail to change the value of selected item by using UpdateIf()

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone. Today, I was asked to add a function on my app: when a item has been created and someone edit it in app, the value of "editcount" in datasource should change to 1 from 0. I used a function UpdateIf('Cer-List',ID=SelectedCerItemID,{OData__x7f16__x8f91__x6b21__x6570_:1}) to realize it, the SelectedCerItemID is the Id of the item which is been selected in the gallery. However, the value cannot be change when it is been selected!

For instance, there are two items and their id is 1 and 2 respectively, I make my code like" UpdateIf('Cer-List',ID=1,{OData__x7f16__x8f91__x6b21__x6570_:1}) ",and I select 1 in gallery——the editcount value won't change.However,If I select 2 in gallery and still make Id=1,The value changes to 1!

(btw. I am a Chinese user and "OData__x7f16__x8f91__x6b21__x6570_"means "editcount" in Chinese)

If any one can offer me advice to fix it, I 'll be really appreciate!Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you want to change the data in datasource?
If so, you can try the Patch function.
Patch function in Power Apps (contains video) - Power Platform | Microsoft Learn

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-zhoqian-msft ,

I tried Patch but my quetion still exist. Once I selet an item in gallery, there will be an OnSelect function like: Set(CerItemID, ThisItem.Id) And my Patch function is Patch('CerList',Lookup('CerList',ID=CerItemID),{EditCount:1}). Would you please use your powerapp and sharepoint list to have a try, to see if you have the same problem as this?Thank you very much!

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

There is no problem in my test.
Will an error message appear? Or there is no error, but the value has not been modified?

This seems to be ThisItem.ID

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No