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,641 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

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,651 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans