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

How to send the mail to designated person (five people in sequence)

Hi, all

who can help me solve this problem? I had read the article that named "send mail to random persons" but it cant help me.

 

1. Owner will receive the user's mail

2. Owner assign the CSR (five people in sequence) to handle

3. Owner create the mission in the planner (also assign CSR)

4. Owner reply user the mail (content: XXX will help you solve this problem)

 

WX20200108-095929@2x.png

2.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How to send the mail to designated person (five people in sequence)

Hi @BonnieTseng,

 

The To field is a string of emails separated by ";", so you can use the split() function to convert it into an array. 

Create a task but not assign it to any user. After getting the array of email, then create an Apply to each action to loop through the Emails array, for example:

Annotation 2020-01-09 163207.png

 

 

Best Regards,
Community Support Team _ Lin Tu
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

6 REPLIES 6
Highlighted
Super User II
Super User II

Re: How to send the mail to designated person (five people in sequence)

HI @BonnieTseng 

 

What's the error you're getting?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Frequent Visitor

Re: How to send the mail to designated person (five people in sequence

@manuelstgomes 

 

Hi, Thanks for your reply.

I don't know how to define the parameter which can make system assign CSR in sequence, because i just use "email to"  in test now.

 

截圖 2020-01-08 下午7.59.58.png

 

Highlighted
Super User II
Super User II

Re: How to send the mail to designated person (five people in sequence

Hi @BonnieTseng 

 

You need to insert the user's emails separated by a semi-colon ";". Something like "a@gmail.com;b@gmail.com"

 

You can use the concatenate function to achieve this. 

 

Then the connector will take care of things for you can convert to the correct IDs and save it to Planner.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Frequent Visitor

Re: How to send the mail to designated person (five people in sequence

@manuelstgomes 

Hi, thanks for your reply.

 

for example, we have five persons (A,B,C,D,E).

I want to assign to A person in the first time, B person in the second time, C person in the third time ....  next time D person.

 

Does this function (concatenate function) to achieve this? thanks

 

 

Highlighted
Super User II
Super User II

Re: How to send the mail to designated person (five people in sequence

Hi @BonnieTseng 

 

That's quite different. You want to do a round-robin between all of them correct?

 

In that case you need to store the "next person in line" somewhere. This is quite easy in SharePoint. You can have a list with the name of the people and the order. Then store the order number and pick the next one in line and add the email address of the corresponding person.

 

Makes sense?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Community Support
Community Support

Re: How to send the mail to designated person (five people in sequence)

Hi @BonnieTseng,

 

The To field is a string of emails separated by ";", so you can use the split() function to convert it into an array. 

Create a task but not assign it to any user. After getting the array of email, then create an Apply to each action to loop through the Emails array, for example:

Annotation 2020-01-09 163207.png

 

 

Best Regards,
Community Support Team _ Lin Tu
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

Helpful resources

Announcements
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.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

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