Unanswered

Sending unique summary email to list with multi person field

(0) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Luckey

Do you have sample input data and an expected output?

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Luckey on at

Like (0)

Report

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

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Luckey on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Luckey on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (2)

Report

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(), '|'))}"

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (0)

Report

Hi @Luckey

I have made a test for your reference:

1.

2.

3.

4.

Best Regards,

Levi

Was this reply helpful? Yes No