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

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (22,386)