cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
axellefevre
Level: Powered On

Show a table from a selected item

Hi,

 

I have a gallery with items from "adventices" table in a screen. I want to show in another screen all the column of a table "test" where test.id = MyGallery.Selected.PrimaryId.

 

How can I process please?

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino
Level 10

Re: Show a table from a selected item

Hi again @axellefevre

 

I think this may be what you are looking for:

LookUp( test, id = MyGallery.Selected.PrimaryId)

This will return the record of test will all the columns.  To return the value of a particular column use this:

LookUp( test, id = MyGallery.Selected.PrimaryId).MyColumn

This will have good performance if test is a collection, maybe a little slow if test is a data source.  If it becomes slow, then you should cache the LookUp expression in a context variable (as a record variable type) when navigating to the screen where you display the data.  Then performance will be very fast.

View solution in original post

1 REPLY 1
Meneghino
Level 10

Re: Show a table from a selected item

Hi again @axellefevre

 

I think this may be what you are looking for:

LookUp( test, id = MyGallery.Selected.PrimaryId)

This will return the record of test will all the columns.  To return the value of a particular column use this:

LookUp( test, id = MyGallery.Selected.PrimaryId).MyColumn

This will have good performance if test is a collection, maybe a little slow if test is a data source.  If it becomes slow, then you should cache the LookUp expression in a context variable (as a record variable type) when navigating to the screen where you display the data.  Then performance will be very fast.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,821)