cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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
Highlighted
Dual Super User
Dual Super User

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

Hi @Anonymous 

 

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
Highlighted
Dual Super User
Dual Super User

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

Hi @Anonymous 

 

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

Highlighted
Anonymous
Not applicable

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?

Highlighted
Dual Super User
Dual Super User

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

Hi @Anonymous 

 

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

Highlighted
Anonymous
Not applicable

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. 

Highlighted
Dual Super User
Dual Super User

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

Hi @Anonymous 

 

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

 

Question is where is the duplicates issue?

Highlighted
Anonymous
Not applicable

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. 

Highlighted
Dual Super User
Dual Super User

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

Hi @Anonymous 

 

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?

Highlighted
Anonymous
Not applicable

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.

Highlighted
Dual Super User
Dual Super User

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

@Anonymous 

 

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

 

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,648)