web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How can I rand(1,40) o...

Power Automate

Unanswered

How can I rand(1,40) only unique numbers, without repeating?

(0) Share

Report

Report

Posted on by Robert94

520

I want to get 40 random items from a sharepoint list based on their ID, but I don`t want them to repeat.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Robert94,

One approach could be to interact with a service like random.org and just collect such a set of unique numbers from there. This way you do not have to do this calculation in Power Automate.

After that you could use the array to retrieve the SharePoint list items with for example an apply to each loop and a get item action.

Below is an example of getting an array with 40 unique numbers in random order:

This hyperlink generates 40 unique numbers in plain text format.

https://www.random.org/integer-sets/?sets=1&num=40&min=1&max=40&seqnos=on&commas=on&order=index&format=plain&rnd=new

split(trim(replace(body('HTTP'), 'Set 1: ', '')), ', ')

Was this reply helpful? Yes No

Join the conversation