combine 2 data sources and display data on single form in power apps

[h11]

Hello All,

I created an app with a Gallery and a form on the same screen by using a SharePoint list. The gallery has details like Project Manager and Project Title. I added 6 columns as fields from the list to the Editform (field names are project status, project created date etc.). I connected the gallery to the form such that if I select a project in gallery, it will show the data of respective fields on the form. Everything is working fine until now.

Recently, I was asked to add 3 columns like project location, project end date and client name from a different SharePoint list into the same form such that if I select the project title in Gallery, it should show the data of all 9 columns (6 from one sharepoint list and 3 from another list)

Please let me know all possible options or formulas to display data.

Any reference videos would be appreciated.

Thanks in advance!

[venturemavenwil]

Do you just want to display the 3 columns on the form?

If you just need to display them, you can probably just add a custom datacard into your form, and then use a label with the Lookup command to fetch the table you need to display. 

[h11]

Hi,

I want to display all 9 columns data ( 6 columns from one sharepoint list and 3 from another sharepoint list ) on the same form.

[venturemavenwil]

Hi @h11 , but you just want to display, and not edit right?

You can add a custom card by clicking on "fields" and instead of click on "add a field", click the 3 dots on the top right hand side to add a custom card. After that, you can simply add a label in the custom card.

You would then have to somehow fetch the data you need from the target SharePoint List. If you have an Unique ID that you can use to look up, I would just use the Lookup command to fetch the data you need. 

If I know your data structure, I can be a bit more specific.