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?
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?
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.
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!