Hi All,
I am working on an app where I have a product list stored in SP containing 2 columns. Code and Name.
I have pulled data into Gallery and added 1 more Custom Field name for Qty.
I have added a checkbox on Gallery item to let people choose the product they want.
OnCheck property of Checkbox I am creating a collection which have Code, Name and Qty in it which is then is pulled in Data table on my ordering page with other customer details. I have given a button to add/edit the quantity which takes user back to product page with check box and qty text field. There I have tried to add update function on ONCHANGE of Qty text field to update the collection but having errors. Most approaches I have used are giving evaluation error "formula uses scope which is not presently supported for evaluation".
Flow of the application is as below.
Open Ordering Form > Choose Add/Edit products > Check the Checkbox for products to order > OnCheck create Collection to add selected item into collection & create another collection to compare Auto Hide function for Qty text field. i.e. if thisitem is in collection show Qty Field, if not Hide Qty Field.. > if user wants to change Qty, Onchange event update new Qty in collection. (problem underdiscussion)
Please advise.
Thank you.
Solved! Go to Solution.
Found the answer.
We would need to find the record against which an update is needed. Using Filter option.
Which should look like below.
Patch(Source,First(Filter(Source,ColumnToFindValueIn= ThisItem.ColumnToMatchValueOf)),{ColumnNameToUpdateValueIn:TextInPutField.Text})
Found the answer.
We would need to find the record against which an update is needed. Using Filter option.
Which should look like below.
Patch(Source,First(Filter(Source,ColumnToFindValueIn= ThisItem.ColumnToMatchValueOf)),{ColumnNameToUpdateValueIn:TextInPutField.Text})
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
196 | |
175 | |
62 | |
34 | |
32 |
User | Count |
---|---|
342 | |
271 | |
112 | |
75 | |
59 |