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!

12 REPLIES 12
Highlighted
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. 

Highlighted

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

Highlighted
Anonymous
Not applicable

@RezaDorrani 

Thank you for your help! 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,601)