Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

between two files to data

Hi everyone,


I have two files of data and there is a relationship between these data. When I click on the data in a file and I want to set up a system that display the data in the other file associated with it.


I tried entities, model-driven app from blank, site map but I could not.

Is there anyone who can help me about this matter?


Very grateful.


Community Support
Community Support

HI @betulb ,

Could you please share a bit more about your scenario?

Do you use CDS Entities to store your data? Do you want to use Model-Driven app to achieve your needs?


Based on the needs that you mentioned, I afraid that the Model-Driven app could not achieve your needs. I think you could consider take a try to create a canvas app to achieve your needs.

On your side, you could consider create a canvas app on your side, and add your two Entities as data source within this app.

Within above created app, add two Gallery controls (Gallery1 & Gallery2), set the Items proeprty of the Gallery1 to following:


set the Items proeprty of the Gallery2 to following:

Filter('YourSecondEntity', RelatedColumn2 = Gallery1.Selected.RelatedColumn1)

Note: The RelatedColumn1 in your First entity is associated with the RelatedColumn2 in your Second entity.

More details about the Filter function in PowerApps, please check the following article:

Filter function


Please also check and see if the following video would help in your scenario:


Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-xida-msft ,


I have three data files and data associated with each other.

For example; file one is t12, file two is t100 and file three is t203. 


The first column of t12 is associated with the second column of t100 and the third column of t203 is associated with the second column of t100.

When I look at the data from the first column of t12, I want to make an application that will show me the data in other files associated with it. (I'm getting the data from MySql)


And I checked the video but doesn't really help.

Can you help me about this scenario?


Thanks a lot.


Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,606)