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
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,703)