cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
u4jaanus
Resolver I
Resolver I

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
u4jaanus
Resolver I
Resolver I

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
u4jaanus
Resolver I
Resolver I

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,838)