Announcements
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
@FureYang use the Patch function. Patch(listName, recordToUpdate, {value:existingValue-1})
Hi @CNT, Alright will try it out .... THX!
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.
@FureYang can I see a screen shot with the error?
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.
@FureYang The 2nd argument in the Patch should be just ThisItem
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 383 Super User 2026 Season 2
Mohsin Ali 356
WarrenBelz 232 Most Valuable Professional
