Sending unique summary email to list with multi person field

[Luckey]

I've been slamming my head on the desk trying to build a flow that will gather all tasks for a user that is in a multi person field. 
I've attempted with variables, but the JSON I'm using doesn't seem to pull out the right information and it's causing an error in the Compose section. 
I start with Get Items, initialize an Array variable and then run a select, mapping the OwnerName. I append those to the array variable and run a union  on the variable. Parse the JSON and >BAM< broken. 

I think I'm missing a step somewhere. 

Or I'm just doing it completely wrong... 

Any help would be appreciated.

[Matthy79]

Hello @Luckey 

Do you have sample input data and an expected output?

[tom_riha]

Hello @Luckey ,

'Select' won't work as 'Select' will just create another array with the emails and you end up with an array of arrays. But you can use a loop to extract all the single users in those multiple people picker fields and continue from there as I explained in this blog post.

[Luckey]

Sure:
Here's the Sharepoint List I'm pulling from. The ITOwnerName is a people picker with multi 

Here's the flow so far. 

I'm wanting to be able to send the ITOwner an email with their AssetName  and status. 

I have tried assembling a Table to see any output. But I either get blank table or errors

[Matthy79]

Hello @tom_riha 

I just skimmed your blog. Is it really necessary to create a loop inside a loop for this? Can you pass me some sample data and the expected output? Normally loops inside loops are very slow and should be avoided if possible.

[Matthy79]

Hello @Luckey 

It would be much more easier with sample data but I hope you can make it from here. All you have to do is to change some fieldnames I guess. You could skip the Select action but the xpath expression would be more difficult.

[tom_riha]

Hello @Matthy79 ,

that's an interesting solution with the xpath, thank you for sharing, I was going through the simplest way possible even though it might take longer to run.

I'd just add that you can't send an email to claims login -> you must replace the  i:0#.f|membership| string in the To field before sending the email.

[Luckey]

Thanks. I actually built most of what I did on your solution. (You have some fantastic stuff there. Thank you for your education.) 
For some reason, when I use your solution, it will spit out each AssetName, but paired all of the found email addresses, not the ones that are actually assigned. 

[Luckey]

When I use this flow, it goes by super quick. But the Filter Array has no data at all. I think that's because the ITOwnerName "contains" Current Item won't find anything. 

[Matthy79]

In the sample the filter formular is "@contains(item()?['ITOwnerName#Claims'], items('Apply_to_each'))"

@tom_riha You are right about the email. But in this case it is easy to get the email value from the Claims-Thing. As you said a replace would do it. I think I would use something like "@{last(split(item(), '|'))}"

[v-liwei-msft · Accepted solution]

Hi @Luckey 

I have made a test for your reference:

1.

2.

3.

4.

Best Regards,

Levi

[Luckey]

Thanks @v-liwei-msft 
However, that doesn't return any data. I think it's because of the multi person picker. 

[v-liwei-msft]

Hi @Luckey 

Could you please show your flow?

Best Regards,

Levi

[Luckey]

[v-liwei-msft]

Hi @Luckey 

Hi @Luckey 

Please make the flow according to the screenshot I provided (this flow is suitable for multiple selection)

Best Regards,

Levi

[Tim_Control]

Hi Levi,

This appears great, and I have tried replicating it for my scenario however I am getting a failure.  To give some background and in case I am misunderstanding:

Attached is a screenshot of the columns in my SharePoint list,  However the main column which I believe is compared to your "ItOwnerName", is detailed below

Responsible Person: Person or Group Column, multiple selection enabled.

When I attempt to slightly adapt your code, the main point that I realise, is that when selecting the "responsibleperson", in the "append to array variable" function, your screenshots facilitate selection of an "item" value, however I do not see this.  I just have the option of selecting email addresses etc.

When attempting to run the flow I get an error, that the code is expecting an array, and that this is delivering an object.

The error is shown in the screenshot, however it is along the lines of execution of the template apply_to_each2 failed.  the results of the evaluation of 'foreachexpression'@'items('Apply_to_each')?['ResponsiblePerson'] is of type 'Object'.  The result must be a valid array.

Please see screenshots and look forward to hearingback any advice you have.

Thanks 
Tim