Lookup a value from multiple lists

%3CLINGO-SUB%20id%3D%22lingo-sub-1118485%22%20slang%3D%22en-US%22%3ELookup%20a%20value%20from%20multiple%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1118485%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20four%20different%20departments%20of%20employees%2C%20which%20all%20have%20their%20own%20SharePoint%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20week%20I%20need%20to%20run%20a%20report%20of%20the%20number%20of%20hours%20each%20employee%20worked%20by%20their%20employee%20%23.%20How%20do%20I%20lookup%20that%20employee%20number%20on%20those%20four%20lists%20and%20bring%20back%20some%20information%20in%20another%20column%3F%20I've%20tried%20excel%2C%20flow%2C%20sharepoint%20and%20I'm%20stuck.%20Help!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1118485%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1118518%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20a%20value%20from%20multiple%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1118518%22%20slang%3D%22en-US%22%3EIf%20you%20are%20just%20needing%20a%20report%20that%20doesn't%20need%20printed%2C%20I%20would%20create%20a%20PowerApp%20to%20do%20it.%20Connect%20it%20to%20the%20data%20source%2C%20and%20use%20a%20collect()%20function%20to%20collect%20the%20hours%20worked%20by%20running%20a%20forall%20loop%20against%20the%20data%20sources%20(the%204%20lists)%20based%20on%20the%20empID%20you%20enter%20in%20a%20text%20field.%20Then%20it%20will%20display%20what%20it%20collects%20into%20a%20gallery%20of%20the%20collected%20data.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 do I lookup that employee number on those four lists and bring back some information in another column? I've tried excel, flow, sharepoint and I'm stuck. Help! 

1 Reply
Highlighted
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.