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

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
Sn3l on at

Like (0)

Report

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.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@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

Was this reply helpful? Yes No
Sn3l on at

Like (0)

Report

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"

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Sn3l on at

Like (0)

Report

Hi Warren.

My field is actually called Reference.

Was this reply helpful? Yes No