Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Gallery based on Lookup function?

Hi Folks -


I have a need to include a non-editable gallery on one of my forms.  For instance, from previous form selections, the end user will end up at the form I am talking about now.  In a text field, will be a value (from a previous gallery selection)

I need the new gallery to use that value on the underlying table and return all values in a certain column.


Here is a picture of the form:



The underlying looks like this:



Therefore, I need all values from "AssetID" column displayed in the gallery.  How would I go about doing this? Would a lookup function work? I've tried but can't seem to get it to work.




@RandyHayes  - thank you so much, Randy!!  Works like a charm!

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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