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

[Anonymous]

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!

[Anonymous]

@RezaDorrani 

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 inputting 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. 

[RezaDorrani · Accepted solution]

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

Regards,

Reza Dorrani

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

[Anonymous]

@RezaDorrani 

Thank you for your help!