web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to set visible sta...
Power Apps
Answered

How to set visible status for gallery item based on if that item is a record in a collection

(1) ShareShare
ReportReport
Posted on by 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. 

Aurora_0-1682343714048.png

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.

 

 

Categories:
I have the same question (0)
  • Verified answer
    Ash13 Profile Picture
    576 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 914

#2
11manish Profile Picture

11manish 627

#3
Valantis Profile Picture

Valantis 598

Last 30 days Overall leaderboard