Power Platform Community Forum Thread Details

I have a simple data table on a canvas app which right now shows all CTN records. The CTN (foxy_presentationctn) relates to a table called Planalyzer (foxy_presentation), as in 1 Planalyzer can have many CTNs.

The Lookup field on foxy_presentationctn is called foxy_Presentation as the schema name, and foxy_presentation as the logical name, and foxy_PresentationCTN_Presentation_foxy_Pr as the relationship name.

I'm trying to have the data table be filtered to only show foxy_presentationctn records where the ID of the related foxy_presentation is b092a7bd-c8f4-ed11-8848-0022483d5ee0 .

I'm just stuck on how to do this as I've been using chatGPT and it has been giving constant wrong formulas. It's saying it should be:

Filter(CTNs, foxy_Presentation.Id = "b092a7bd-c8f4-ed11-8848-0022483d5ee0") but that gives an error in the formula. It also gave DataTable1.Items = Filter(CTNs, foxy_Presentation = "b092a7bd-c8f4-ed11-8848-0022483d5ee0") which gives the same error.

Any suggestions?

Categories:

Building Power Apps

Hi @dfsdfsdfsdfsdfs,

This might be oversimplified but if I am reading this correctly, you want to Filter a Gallery linked to Table 2 (foxy_presentationctn), based on a Related field selected from Table 1 (foxy_presentation).

As a basic example, add a ComboBox control into your Screen and set the Items property to Table 1.

In the Gallery, set the Items property to:

ComboBox1.Selected.'The Plural Name of Table 2’ (The Relationship Name of your Lookup Column)'

The syntax requires the plural name of Table 2 together with the Relationship name. If you simply enter ComboBox1.Selected and enter the period/full stop key (.), intellisense will automatically display the correct field you need:

Table Plural Name:

Relationship Name of your Lookup Column:

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution

If you like my response, please give it a Thumbs Up.