Send Email to random users

(0) Share

Report

Posted on by anabananei

195

Hello Everyone,

Anyone can help me on my problem?

When an item is created, a survey will be sent out to random users from my team. I have 17 people on my team and the survey should only be sent to 5 random people every time a new item is created. The 5 selected people should not be the same as the previous days. Is this possible in Flow?

Many thanks!

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Hi @anabananei ,

What is currently achievable is to randomly extract five users, but there is no guarantee that these five people will not be duplicated, because Rand() function may get the same result in a small range.

What's hard to achieve is that the second time the user to be sent, the previous user needs to be excluded.

Because it is necessary to record the previous personnel, how to obtain it when the next execution of Flow is a difficult point.

Anyway, I created a flow that randomly selects five users, you could use it as a reference.

Create a list to record the user information, create a new Person type column to select user, and give each user a number, you could consider directly using ID as a number.

Flow configuration:

Please take a try.

Best Regards,

Was this reply helpful? Yes No
anabananei 195 on at

Like (0)

Report

Hi @v-bacao-msft ,

I have tried your flow and it works. The only problem is that instead of 5 results it only gives me 4. I mirrored your flow exactly. What do you think seems the problem?

Thank you,
ANa

Was this reply helpful? Yes No
anabananei 195 on at

Like (0)

Report

I tried changing the value of "minimum value" in random expression from 1 to 5 and it gave me 5 results. Do you think this is the correct workaround?

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report
Hi @anabananei ,

Yes, this problem has been mentioned in my previous post, because the range of values is relatively small, so rand() function may get the same value.

And I use union() function to remove duplicate values, so you don't necessarily pick up five users.

I have improved it, please refer to the screenshot below for improvement.

Expression:

length(union(variables('Email'),variables('Email')))

Please take a try.

Best Regards,

Was this reply helpful? Yes No
anabananei 195 on at

Like (0)

Report

Works perfect! THank you!

Was this reply helpful? Yes No
erkindunyaWork 30 on at

Like (0)

Report

Hi,
Thanks for the solution, is there any chance we only send email/ select to single user, using
rand(1,2), and set field called Selected on user list using Update item to set it Yes, so we not select this user again
by putting checkes before Get Item rand(1,2).

many thanks

Was this reply helpful? Yes No
bbkbhattarai 2 on at

Like (0)

Report

Hi,

I am pretty new to using flow and still in learning phase. I was trying to do get one user from the list to get email randomly with details recorded from a form, asking them to complete a task based on that.
This thread seems like the one that will be useful for me, but since I am so new to flow, I could not carry out the steps as explained here. Will it be possible for you to explain the steps in more layman term please. I am trying to randomly select one member from our team to review other persons work.

The person who carries out the task will complete a Microsoft form and based on that, any random member from team, except the one who completed form, will receive an email to complete the review. It will be helpful to have follow up, if the reviewer does not complete the review in say a week time or so.

Many thanks for your help in advance.

Regards
Bebek

Was this reply helpful? Yes No
JibblyGibbly 44 on at

Like (0)

Report

I have a similar problem I’m trying to solve.
I am trying to create a power automate to ask a number and it displays N number of office 365 users at random from our Azure AD.
this comes in handy when we want to set up focus groups, create committee etc.

many help would be greatly appreciated.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Hi @JibblyGibbly,
and what's your problem?
Did you try to reproduce the flow provided by @v-bacao-msft ?

Was this reply helpful? Yes No