How to do a foreach on unique values from a SP list

(0) Share

Report

Posted on by Luigi312

Hello,

I have managed to retrieve the content of a SP list, which looks something like this:

ID | Customer Name | Assigned person

1 | Customer 1 | Bob

2 | Customer 2| Bob

3 | Customer 3 | Jack

4 | Customer 4 | Jack

What I would like to do is send a single email (every two week for example) to each "Assigned person" with the list of all the opportunities assigned to him. Eg.:

Bob will receive an email with the information regarind Customer 1 & Customer 2.

Jack will receive an email with the information regarding Customer 3 & 4.

I have tried the following flow:

Recurrence > Get Items > Create HTML Table > Send Email

This works fine, but I'd like to send only the relevant information to the right people in "Assigned person".

Any thoughts?

Categories:

General topics

I have the same question (0)

All responses (16)

Answers (0)

Sort by

Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Luigi312
I would suggest nested apply to each loops:
1) An outer loop for each assigned person
2) An inner loop that threads through the opportunities for that person and composes a single email text
Please let me know if you need details

PS Here is a reference:
https://flow.microsoft.com/es-es/blog/nested-apply-to-each/

Was this reply helpful? Yes No
Luigi312 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Meneghino.

The issue is: I can't do an Apply to each with other values than the Sharepoint lists items, or the entire Output of a "Select". I can't do an Apply to each on single items. Eg. : Apply to each "Leader"

So I've ended up with this, but this doesn't work ...

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!
OK, there are two possible alternative approaches:
Add another 'Get items' step which will get the items grouped by Leader, so that you can have a list of leaders that you can iterate through for the outer loop. Please note that the send email should be outside the inner loop but inside the outer loop, since you want to send only one email per leader
Use only one 'Apply to each' loop, but use a variable to keep track of the current Leader. If the leader changes, then you send the email and reinitialise the variables. In this case your 'Get items' step will need to get the items ordered by Leader
Please let me know if anything is unclear

Was this reply helpful? Yes No
Luigi312 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I couldn't make it work. Tried everything. I am giving up.

Thanks for your time and patience.

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

It can be done, please Skype me to discuss.
Skype is baizini

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

PS What type of column is customer? (text, choice or lookup)
What type of column is Assigned person? (person, text, choice, or lookup)

Was this reply helpful? Yes No
anhthuch4ng Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Luigi312 and @Meneghino,

We you two able to meet on Skype to discuss a solution to this?

Hoping that conversation was helpful,

-AT

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, we did, thank you. It was resolved, I believe. Flow is a very good product, much more robust than PowerApps.

Was this reply helpful? Yes No
TwoPuttTommy 9 on at

Like
a
(1)

Report
Copy link

Link copied!

Can you post the solution on this board? I'm having the same problem and can't figure this out.

Thanks!

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like
a
(3)

Report
Copy link

Link copied!
Basically:
Initialise Email body variable with nothing
Get the items
Initialise the OldAddressee variable with the first item
For each of the items
If this item=last item or CurrentAddressee<>OldAddressee
then
If this item=last item add current item content to Email body else nothing
Send email to OldAddressee with Email message
Clear Email body variable
Set OldAddressee=CurrentAddressee
else nothing
Add current item content to Email body

Was this reply helpful? Yes No