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

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

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

Hi @erikah 

 

Run add row to excel seeprately for each list

 

Apply to each list 1

-> add row

finish the loop

 

 

 

then next loop

apply to each list 2

-> add row

 

 

Capture.PNG

 

Regards,

Reza Dorrani

 

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

View solution in original post

12 REPLIES 12
Dual Super User
Dual Super User

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

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
Level: Powered On

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

@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?

Dual Super User
Dual Super User

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

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
Level: Powered On

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

@RezaDorrani 

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

Dual Super User
Dual Super User

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

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
Level: Powered On

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

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

Dual Super User
Dual Super User

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

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
Level: Powered On

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

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.

Dual Super User
Dual Super User

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

@erikah 

 

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

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,156)