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

(1) Share

Report

Posted on by 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!

All responses (6)

Answers (0)

Suggested answer

opticshrew 193 on at

Like (1)

Report

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

I'd add a custom data card and as suggested already, use a lookup to populate with the data you want to reference.
SamFawzi-SmartSolut... 258 Super User 2025 Season 1 on at

Like (1)

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

Hey, Try using this code

Coalesce(LookUp(Report, 'Project Code' = Gallery1.Selected.'Code*', 'Date'), "Not Found")
h11 4 on at

Like (1)

Report

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

Hi @venturemavenwil - Thank you for your response. I used the Lookup formula to fetch the data.

In my app, I have a SharePoint list displayed in the gallery, and the form includes all fields from this list, which functioned perfectly. However, after adding a custom card to the form with the bottom three fields sourced from a different SharePoint list, I had issues. The Lookup formula only works for some projects, while most return an error. Below are the screenshots and formulas I've used, where a unique id named 'Project Code' is utilized to retrieve fields from the second SharePoint list.

1. Formula I used to get the data on the data from the Gallery is:
Sort(Filter(

PriorityCollect,

StartsWith(Title, TextInput2.Text) &&

('Project Status'.Value = Dropdown3.Selected.Value || IsBlank(Dropdown3.Selected.Value)) &&

('Project Manager'.DisplayName = Dropdown1.Selected.Value || IsBlank(Dropdown1.Selected.Value))

),ThisRecord.'Priority Ranking',SortOrder.Ascending

)

2. Formula I used to lookup for date on the custom card with different SharePoint list:

Coalesce(Text(LookUp(Report, 'Project Code' = Text(Gallery1.Selected.'Code*'), 'Date')),"Not Found")

I got results for 10 out of 500 projects after I used the above formula.

Image:

Other 490 projects didn't show up results.

Image:

Please assist me by identifying where am I going wrong, so that I can apply the correct formula to retrieve the data. Thank you!
venturemavenwil 590 Super User 2025 Season 1 on at

Like (1)

Report

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

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.
h11 4 on at

Like (1)

Report

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

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 590 Super User 2025 Season 1 on at

Like (1)

Report

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

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.