what is the recommended ways to update an item in Microsoft List (a predefined number) by reducing it by X number for every Power App Button press.
let say i have 100 unit and every Button Press will reduce it by 1
Solved! Go to Solution.
@FureYang use the Patch function. Patch(listName, recordToUpdate, {value:existingValue-1})
@FureYang use the Patch function. Patch(listName, recordToUpdate, {value:existingValue-1})
I have tried to edit as such:
OnSelect: fx= Patch(NumberControlTest,ThisItem.Quota,{Value:ThisItem.Quota-1})
But it seems that the formula have errors. likely defined incorrectly for "{Value:ThisItem.Quota-1}" part.
The app is to update a Microsoft List item. So i was intended to make a button to update the Quota Column as I select the Button.
@FureYang I see only the red lines but not the Error Message! Hoover over the red line to see the error message. Also, what is the data type of the Quota column?
Sorry about that.
Here is the error message: Invalid argument type (Number). Expecting a record value instead.
The Column is defined as a number by the way.
@FureYang The Value column in NumberControlTest is expecting a record. I'm not sure what is the structure of this? Can you provide all the details please?
Sure. I'm trying to create an App out of Microsoft List.
So the list looks as such:
Then Integrate it to Power Apps.
Then, from the Edit Form page, i am trying to insert a button for the Quota item to update its value.
User | Count |
---|---|
141 | |
97 | |
89 | |
78 | |
56 |
User | Count |
---|---|
191 | |
187 | |
105 | |
99 | |
91 |