Unanswered

Select three random items from a SharePoint list

(0) Share

Report

Posted on by NeilCIT

Hi there, I have a flow which currently takes values from two lists and based on certain criteria, then adds items to a separate SharePoint list. I then want to be able to select three of the items in the newly updated list. I have found lots of articles around selecting one item but I need to select three.

Ultimately the three selected items are users and an email will be sent to them...

Can anyone help me?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report

Re: Select three random items from a SharePoint list

Hi @NeilCIT ,

So what's your criteria to select the three items?
For example, you can select three items based on their similar parameters in "Filter Query", or you can fill "Top count" with 3 to get the top 3 items:

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

Was this reply helpful? Yes No
NeilCIT 2 on at

Like (0)

Report

Re: Select three random items from a SharePoint list

Hi @v-wenjuan-msft
So the new list literally just contains names (M365 Display names), and I just need to pick 3 randomly. When it says 'top count' does it mean the first three in the list? I need a fully random selector...

Was this reply helpful? Yes No