Forum Discussion
Lookup a value from multiple lists
We have four different departments of employees, which all have their own SharePoint list. Each week I need to run a report of the number of hours each employee worked by their employee #. How d...
If you are just needing a report that doesn't need printed, I would create a PowerApp to do it. Connect it to the data source, and use a collect() function to collect the hours worked by running a forall loop against the data sources (the 4 lists) based on the empID you enter in a text field. Then it will display what it collects into a gallery of the collected data.