Showing results for 
Search instead for 
Did you mean: 
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!

Not applicable


Sure thing.

The hardest part for me is that it would create a different action every time I tried to add a different list to the table category. I was able to minimize when I waited to add the new list until I finished inputtinglist1.png the previous list. I don't know if that makes sense. Should I put the Get Lists parallel to each other instead of underneath? I'm assuming that makes a difference. 

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






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

Not applicable


Thank you for your help! 

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,872)