between two files to data

[betulb]

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.

[v-xida-msft]

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:

'YourFirstEntity'

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:

https://www.youtube.com/watch?v=nlhWQg03TL0

Best regards,

[betulb]

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.