You’re offline. This is a read only version of the page.
364
Hi all,
Sorry if the title is confusing. I am trying to make a rectangle I have inserted into a gallery become visible if 2 conditions are met.
Clicking the "Confirm Part Quantity" adds a row to my collection "colCount". This collection contains the "Part Number" and "Location" for every record.
What I would like to do is, make a rectangle become visible in the second gallery (the gallery on the right) if the part number and location for each record are inside the collection. The second gallery uses the DataSource "Part_Stock" and has the same columns for part number and location.
I have tried writing something along the lines of:
If(LookUp(colCount, Text(Location) = ThisItem.STK_06).Location && LookUp(colCount, Text('Part Number') = ThisItem.PRT_06).'Part Number', true, false)
but obviously this does not work. If anyone has any suggestions for what I can do in this scenario, I would greatly appreciate it. Thanks.
Try using the "in" operator by setting the Visibility of this rectangle to:
ThisItem.STK_06 in colCount.Location && ThisItem.PRT_06 in colCount.'Part Number'
This will return true if both conditions are satisfied and therefore the rectangle will be visible
#1
WarrenBelz
146,594
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
