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

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (109,624)