News and Announcements icon

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

Power Automate - Building Flows

Unanswered

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

Like (0) Share

Report

Report

Posted on 7 Apr 2022 09:47:21 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:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 31,701 Most Valuable Professional on 07 Apr 2022 at 10:52:16

Like (0)

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

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: ', '')), ', ')

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Leaderboard > Power Automate - Building Flows

#1

stampcoin 125

#2

David_MA 109 Super User 2025 Season 1

#3

Michael E. Gernaey 90 Super User 2025 Season 1

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans