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 Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps 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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (4,510)