DataTable to show only Records of item Selected

(0) Share

Report

Posted on by Sn3l

Hi All,

I have a form the shows data from 2 x Sharepoint lists

List1 with a Record called Reference (1 x Record in this table)

List 2 with Record Called GetRef ( Many Records relating to table 1.) (This is Same ID just one to many)

I have a PowerApps form on which my Reference from List1is displayed. Called RTReference

And a I have a Display table in which I would like to display all the relating records from Tbl2 called GetRef

On the Table to get the data in "Items"I have tried

Filter(Tble2,GetRef)= "RTRefernce" and various other ways of displaying the data with no avail.

Any suggestion would be appreciated

All responses (6)

Answers (0)

Sn3l on at

Like (0)

Report

Re: DataTable to show only Records of item Selected

Hi Warren.

My field is actually called Reference.
WarrenBelz 146,524 Most Valuable Professional on at

Like (0)

Report

Re: DataTable to show only Records of item Selected

@Sn3l ,

Instead of Reference, you need the name of the Text Box that the Reference field is contained in the Form. You simply need to establish the Reference value in the Lookup.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Sn3l on at

Like (0)

Report

Re: DataTable to show only Records of item Selected

I seem to be having some troubles today.

Reference Field sit on a from called (Requested travel)

Tbl2 is called Suggested Travel.

With the above I get the error "Name isn't valid. 'text' isn't recognized"
WarrenBelz 146,524 Most Valuable Professional on at

Like (0)

Report
Re: DataTable to show only Records of item Selected

@Sn3l ,

Correct - Forms do not have a Selected as they contain only one record. You simply need the Reference - if it on the Form (you can hide it if you want) in a Text Box, then

Filter( Table2, GetRef = Value(TextBoxName.Text) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Sn3l on at

Like (0)

Report

Re: DataTable to show only Records of item Selected

Hi @WarrenBelz
Thank you for the prompt response.

I am not getting the Table 1 data from a Gallery. It is only a reference field that is on my form.

If I go.

Filter(Table2, GetRef = FormName.Selected.Reference ) The "selected option: does not function.
WarrenBelz 146,524 Most Valuable Professional on at

Like (0)

Report
Re: DataTable to show only Records of item Selected

Hi @Sn3l ,

Firstly you need to define which Reference from Table 1 you are matching on - example if the Table1 record is selected from a Gallery, it would be

Filter( Table2, GetRef = GalleryName.Selected.Reference )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps