Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

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 Team
Community Support Team

Re: between two files to data

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.
Level: Powered On

Re: between two files to data

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 Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


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


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,664)