cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

thisitem in Gallery issues while working with collections

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.

Capture.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Helper II
Helper II

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})

View solution in original post

1 REPLY 1
Helper II
Helper II

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})

View solution in original post

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (8,776)