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

From Gallery to datatable

Hi,

 

i have 2 views on my Azure SQL DB (2 Tables - Members and Salescards) both table has an Adressnumber for Primary key.

 

A Member can have one or several SalesCards.

In PowerApps i have a gallery to list the Members with view1 from my Azure SQL DB.

I have a Detail From to show the Detail from the Member e.g. Adress, stress..

Additionaly i have a Datatable and i want see here with my view2 the salescard for the selected Member.

Both tables in my views has a field Adressnumber as Primary Key.

 

Is it possible to link this 2 views to get the salescard for the selected Member?

 

Has anyone a idea how can do this?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: From Gallery to datatable

Hi @Tamer66,

 

Do you want the DataTable’s salescards based on the gallery’s selected Addressnumber.

I think you can use filter formula to test.

Filter(View_Salescards,Addressnumber=Gallery.Selected.Addressnumber)

 

I test as next:

DataSource: View_members

                     View_Salescards

20190211datatablesource1.png

20190211datatablesource2.png

AppTest:

Gallery1.Items: '[dbo].[View_members]'

DataTable2.Items: Filter('[dbo].[View_salescards]',Addressnumber=Gallery1.Selected.Addressnumber).salescards

 

20190211datatableapptest.png

 

Result Test:

20190211datatablebasegallery.gif

 

Hope this can be helpful.

Best Regards.

Yumia

 

1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: From Gallery to datatable

Hi @Tamer66,

 

Do you want the DataTable’s salescards based on the gallery’s selected Addressnumber.

I think you can use filter formula to test.

Filter(View_Salescards,Addressnumber=Gallery.Selected.Addressnumber)

 

I test as next:

DataSource: View_members

                     View_Salescards

20190211datatablesource1.png

20190211datatablesource2.png

AppTest:

Gallery1.Items: '[dbo].[View_members]'

DataTable2.Items: Filter('[dbo].[View_salescards]',Addressnumber=Gallery1.Selected.Addressnumber).salescards

 

20190211datatableapptest.png

 

Result Test:

20190211datatablebasegallery.gif

 

Hope this can be helpful.

Best Regards.

Yumia