Merge multiple sharepoint list People Picker

[aliciaf]

Hello. Thanks for all the help everyone on this board gives. 

I read all of the suggested posts and only one involved non-collections. 

I have a horrible problem, but i know there is a solution. due to circumstances, i cannot screen shot off my laptop or copy/paste. I will do my best to answer. I tried talking the team out of this- but they have 7 sections with between 20 and 120 metrics per section. The only want to acomplish this was through 7 different lists. The power app does what it is supposed to do. 

The second part, the part that i need help with is how to get those 7 lists merged into one to either email or save to sharepoint. I do not have premium connectors. 

I have done this with no problem with one list. The other issue is I do not want to write out 120 different metrics. The lists only share 5 common metrics. 

So far I followed this tutorial as the best: Power Automate - Multiple SharePoint Lists and Report (youtube.com) @abm I only want to retrieve the last submission from each list. 

My flow is

triggered by Powerapps

I collect the sharepoint list names

i think split them by ","

*I need to initialize a variable here as this is my problem*

Apply to each (per sharepoint list) using the outputs (split sharepoint list names)

compose sp list name

get items from each list

*i need to compose a variable here as this is my problem*

compose details where I assigned the common column names as a check. I would like to dynamically list only the non-blanks, but thinking i might have to download to excel and then upload non blanks. Other option would be to create an array (from the excel) of the column names and an array of the column data and then transpose. boom! put it into html table and they can decide what they want to do. 

Everything works EXCEPT for my auditors column. This is a multi select people picker. when it was just one person it was not an issue, but i tested it with multiple people and it is throwing errors all over the compose after get items. 

help?

By the way, if you can come up with an easier solution, i am all ears. I am above novice. slightly above beginner but not nearly close to comfortable.