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

12 REPLIES 12
Anonymous
Not applicable

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

 

 

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

Anonymous
Not applicable

@RezaDorrani 

Thank you for your help! 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (918)