Can I combine 3 different Data Sources to Create one summary or report?

[erikah]

The purpose of my app is to create a log of different training that agency employees have completed for HR to review and have. 

There are 3 specific Sharepoint Lists that I created in order to separate and list everything that HR needs. I'm working on the Detail Form and realized that it can only read one Data Source. That's a problem. I need to be able to combine this data. Is there a way to do this using Powerapps? I was hoping they could export a report.  Ideally, I would love HR to be able to see what Individual Employees have completed and have a running total of hours they have achieved vs. how many are still needed to complete for the year. Thanks in advance!

[RezaDorrani]

Hi @erikah 

Form control in PowerApps can only be connected to single data source

Moreover, since your requirement is to export information, your bets bet would be to execute a Microsoft Flow from PowerApps which can perform the merging of data from all the lists and post it to the user in the format desired

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[erikah]

@RezaDorrani  oh! Ok, Do you know anything about using flow? I'm telling it to Get items from Sharepoint and I'm getting a lot of duplicate information. Is it because I'm stacking it?

[RezaDorrani]

Hi @erikah 

Get Items will return a collection of records based on the query performed

Duplicate information may be because ur list contains duplicate info or when combining data from multiple get items you are duplicating it

Post screenshot of flow here

[erikah]

@RezaDorrani 

Here they are. I did make sure that each value was from each list. 

[RezaDorrani]

Hi @erikah 

So your flow queries each list and then adds all records to the excel file

Question is where is the duplicates issue?

[erikah]

The duplicate issue is in Excel. I added myself to each of the lists. This is what populates. 

[RezaDorrani]

Hi @erikah 

Get items will get all items from your list and then add to excel will push it to excel as a data row

Assuming you excel file is empty prior to populating it with Flow

Then the data being loaded into excel is the data coming from the 3 lists

check to see if there is duplicate data already in your lists

or do you want to query only specific data from the lists to add to excel?

[erikah]

Those lists are empty. I had gone through to make sure. I also cleared out the rows in Excel. There should only be 3 queries in that excel workbook. One from each list. The Flow filled 149 rows and it's just the same information over and over again.

[RezaDorrani]

@erikah 

can you post snapshot of data in SP List and snapshot of your flow with actions expanded view