cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Send emails group by Responsible person

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 emailAsset name

Maria

Prospero
MariaLe Monge
MariaKopernik A
JhonKopernik B-E
JhonRondo 1
JhonAlma Shopping
JhonMarievik 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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Frequent Visitor

Re: Send emails group by Responsible person

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:

1.png2.png3.png4.png

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

 

Thank you

 

View solution in original post

Highlighted
Community Support
Community Support

Re: Send emails group by Responsible person

 

Hi @manuelatarabuta ,

 

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

56.PNG57.PNG58.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Highlighted
Community Support
Community Support

Re: Send emails group by Responsible person

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Send emails group by Responsible person

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:

1.png2.png3.png4.png

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

 

Thank you

 

View solution in original post

Highlighted
Community Support
Community Support

Re: Send emails group by Responsible person

 

Hi @manuelatarabuta ,

 

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

56.PNG57.PNG58.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Frequent Visitor

Re: Send emails group by Responsible person

@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: 

if yes.JPG

How can we solve this?

 

Many thanks

Manuela Tarabuta

Highlighted
Frequent Visitor

Re: Send emails group by Responsible person

@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:

space.JPG

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

 

Many thanks,

Manuela T.

 

Highlighted
Community Support
Community Support

Re: Send emails group by Responsible person

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Send emails group by Responsible person

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:

manager.JPG

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

Many thanks,

Manuela T.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (7,380)