cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CtX
Level: Powered On

Is it possible to alternate which person gets an email notification?

So I'm kind new to flow but i managed to create a forms to prioritize a few tasks and a flow to send emails to certain adressess based on answers but the problem is:

I need it to alternate who gets emailed like this:

If question a is chosen it is going to email user 1, if question a is chosen once again email goes to person 2, if question a is chosen again it goes back to person 1 and so on (alternates between 2 emails).

Same goes for other questions

 

Is microsoft flow capable of doing this?

3 REPLIES 3
Super User
Super User

Re: Is it possible to alternate which person gets an email notification?

@CoX
I would create a SharePoint list with one row of data. When you need to send the email, check the list and grab the email address. Then update the list to reflect the other email.

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

Scott
CtX
Level: Powered On

Re: Is it possible to alternate which person gets an email notification?

Hello, thank you for replying.

How do I do that? I'm not familiar with sharepoint, could u show me a simple example? Is that the only possible way? 

 

NazIM
Level: Powered On

Re: Is it possible to alternate which person gets an email notification?

Do you know where your Form is storing the data. Usually, I get my forms to store data to an Excel sheet online (OneDrive or Sharepoint).

 

You can then use the Flow to open the Excel file, "Get Rows", find the last entry and do a "Condition" check to see if the last person is "X". If yes, then send email to "Y", if not, send email to "X".

 

Hope I've explained it well enough for you.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,087)