cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper 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
Highlighted
Helper I
Helper I

Re: thisitem in Gallery issues while working with collections

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
Highlighted
Helper I
Helper I

Re: thisitem in Gallery issues while working with collections

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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,632)