Only one control for manage several Tables

[Emerald64]

Hello, is it possible in powerapps to browse and update records of several Tables using only one Control for Browse records, one Control for view record selected, one Control for Edit record selected ? for example I have Table1, Table2, Table3, so I have 3 gallery Controls (BrowseGallery1, BrowseGallery2, BrowseGallery3) everyone with different value in “Items” for connect to related Table: it is possible having only BrowseGalley1 where i can put in “Items” the Connection string to desired Table ? and similar for FormViewer1, FormViewer2, FormViewer3 (only one) and EditForm1, EditForm2, EditForm3 (only one)

I hope it is possible help me…Tank You !

[Anonymous]

Hi

Yes you could imagine some kind of filters to click on that will save the name of a specific table in a variable . The gallery will then use the variable in its Items property. I think you will have to play with the Visible properties too to display some fields only if some specific data source is selected.

Another idea could be to create a collection storing all your different tables. So you gonna have one table including all the 3 others and maybe try to filter the gallery at that point

regards

[Emerald64]

I have saved the name of a specific table in a variable but i can't use a variable for refer the Table (i can use variable only for refer to value of field)

To create a collection storing all my different tables i think (in my case) is not possible.

but...THANK YOU ! for support

[v-xida-msft]

Hi @Emerald64,

Could you please share a bit more about your scenario?

Do you want to display records in your three Tables within single one Gallery? Or View/Edit records in your three Tables within a single one Display form/Edit form?

Further, do your three Tables have same data structure?

If your three Tables have same data structure, I think single one Gallery/Display form/Edit form could achieve your needs within PowerApps.

If your three Tables have different data structure with each other, I afraid that there is no way to achieve your needs in PowerApps currently.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,

Kris

[Emerald64]

hi, the three Tables have same data structure.

I would like using only one control for view Table1 or Table2 or Table3 , it is also the same for me view Table1+Table2+Table3 and next filter the Table desired.

Similar

I would like using only one control for edit Table1 or Table2 or Table3 , it is also the same for me edit Table1+Table2+Table3 and next filter the Table desired.

THANK YOU for Support !

Best regards

Roberto

[Emerald64 · Accepted solution]

Hi, I have partially resolve with a test on DataTable1.Items: Switch(v_Progetto;"Miulli";Attività_1;"Barilla";Attività)

But, the great ask is: is possible in powerapps create a connection object ?

Similar:

Set p_Conn1 new connection

p_Conn1 = https://gruppoprova.sharepoint.com/sites/pwa/Elenco1

BrowseGallery1.items = Conn1

Exist in powerapps a similar possibility?

Thank you

[v-xida-msft]

Hi @Emerald64,

Do you want to create a connection object within PowerApps?

If your three tables have same data structure, I agree with your thought almost, I think the Switch function could achieve your needs in PowerApps.

If you want to create a connection object within PowerApps, I afraid that there is no way to achieve your needs in PowerApps currently.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,

Kris

[Emerald64]

Thank you Kris, i have post This proposal: Connection object

best regards

Roberto