web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Need help writing a fo...

Power Automate

Answered

Need help writing a formula/code snippet

(0) Share

Report

Report

Posted on by Usernametwice

503

Hi all

I am creating a flow and its currently getting the first user record based on a list of users/records.

Here is the compose snippet which currently gets the first user id from the list:

first(outputs('List_rows')?['body']?['value'])?['systemuserid']

What I would like to do now is change this snippet so that it gets the records in the list at random and not be the first record all the time.

I have tried using the rand function many different ways but cant get it right.

Does anyone know how to write it correctly? I would really appreciate it!

Thanks in advance all!

Categories:

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Usernametwice23,

You could combine a rand function with the length of the array and use a skip and a first to get a random item.

Try something like below:

first(skip(outputs('List_rows')?['body']?['value'], rand(0,length(outputs('List_rows')?['body']?['value']))))?['systemuserid']
RobElliott 10,539 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!

@Usernametwice23 I have a flow that gets 1 random country each day from a SharePoint list for our intranet. The compose action has the following expression:

body('Get_items')?['value'][rand(1,length(body('Get_items')?['value']))]

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RobElliott,

Great to see that also works, that looks a lot simpler compared to what I suggested 😁

Only suggestion I would have would be to start the range with the 0. Otherwise the first country record will always be ignored from the random pick 😉

Join the conversation