Send emails group by Responsible person

[manuelatarabuta]

Hi,

After long research through lots of workflows that are similar to what I want to achieve, I finally managed to reach one suitable for my situation, but did not sent emails grouped by responsible persons with related assets, but sent to all of the responsible persons with the whole list of assets, and 2) did not stopped after running once and sent at least 20 mails until I managed to cancel it..I feel that I'm rounding in circle and perhaps missing an important detail..

I mention that I need it to run it whenever, no specific timeframe required..

This is my table:

Responsible Person email	Asset name
Maria	Prospero
Maria	Le Monge
Maria	Kopernik A
Jhon	Kopernik B-E
Jhon	Rondo 1
Jhon	Alma Shopping
Jhon	Marievik 28

I want to group them in an email as here:

to: Maria

"Hi,

Please update the assets:

Prospero

Le Monge

Kopernik A

"  

to: Jhon

"Hi,

Please update the assets:

Kopernik B-E

Rondo 1

Alma Shopping

Marievik 28

I would like to start it from scratch as I can not paste any image here..

really appreciate your help..

I've been followed this post exactly as they are there...

https://powerusers.microsoft.com/t5/General-Power-Automate/Need-to-trigger-Single-email-for-same-set...

Thanks

[v-bacao-msft]

Hi @manuelatarabuta ，

Could you share a screenshot of Flow's configuration so that we can provide you with appropriate suggestions to update the configuration?

What is the problem you are currently experiencing? Please provide more details.

In addition, there is a similar thread, I have provided a suitable solution in it, please check it and see if it helps:

https://powerusers.microsoft.com/t5/Building-Flows/Sending-Scheduled-Emails-with-Excel-Rows-Included...

Best Regards,

[manuelatarabuta · Accepted solution]

Hi @v-bacao-msft,

Thank you for the response, I want in the end to have in the body of the email the Asset Names that refer to that specific person (maria/Jhon) in a row delimited by comma; in the original table I have person's email as Responsible person. 

I need to send them a single time a Notification email to update data referring to the buildings they are responsible for, so they won't receive >10 emails as they have more buildings assigned.

My current workflow is:

Please advise me if I have to do it other way or just to change something..

Thank you

[v-bacao-msft · Accepted solution]

Hi @manuelatarabuta ,

Please try to refer to the following screenshot to configure flow:

Best Regards,

[manuelatarabuta]

@v-bacao-msft  really appreciate your answer, I am currently trying to build the flow but I got on error at  Condition -> If yes, and I am sure I did write down as you did.. as below: 

How can we solve this?

Many thanks

Manuela Tarabuta

[manuelatarabuta]

@v-bacao-msft sorry for the latest message, I managed to sort it out(I misspelled a ; instead of :   . 

I have some news: your workflow WORKED perfectly!! Really appreciate.

Just one thing to polish, one of the emails came with the table format inside of email's body with a huge white space between Header and table rows as here:

I am sure there is a solution here though... 

Many thanks,

Manuela T.

[v-bacao-msft]

Hi @manuelatarabuta ,

I am not sure about the configuration of your Flow. If you configure Flow exactly according to the method I provided, there will be no such problem. Don't leave a big blank when configuring Email body.

The location of each action needs to be configured according to the screenshot I provided. When choosing Dynamic content, you need to choose the correct one.

Best Regards,

[manuelatarabuta]

Hi @v-bacao-msft , even though the current workflow worked great, I want now to find a solution to chase those Responsible Persons from whom we did not received requested Asset information data yet and cc -ing their Manager so they will become more responsible. 

Not sure in where to fit some other steps so I can extract information from "Manager" column and to keep as well the initial form of the workflow(requesting to each group of persons information for their Assets and then specify the Asset names in the body of the email). 

Let's consider this list means only to be chased persons, my list is something like:

Would appreciate very much your advice where to add extra steps at the initial workflow.

Many thanks,

Manuela T.

[Sajjad_Khan]

Hi @v-bacao-msft ,

Inside Apply to each 2, you have apply to each 3 how can we get that currentitem for apply to each 2, please explain this part a bit I'm fresher. Thanks in advance.