Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get random item from a list



I have a growing list of tweets I'd like to select from at ramdom and send on a schedule every week or 2 to promote some business.


Is there a way to store this list and have Flow select from at random and send using the scheduled task trigger?



Community Support
Community Support

Hi Phawkshaw,


Could you provide some information about:
1. what is your list type? is it a SharePoint list?
2. what kind of data do you want to get at random?
3. Do you mean that you want to run a flow on a schedule by using Recurrence?


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable



The list isn't in any particular store at this stage.  I dont mind where I have to store it to get the job done.

The data I want to fetch at ramdom is the tweet text to pass into a twitter post.

Yes I was hoping to use the Recurance in Flow to manage the schedule.


I think the hardest bit is the random selection stage?


Many thanks.

Continued Contributor
Continued Contributor

There won't be a simple way to do this. You can use Azure functions to achieve it(Ref: You can use Math.Random and Math.Floor to generate a random value between a given range(Ref:


1. Create Azure Function with Math.Random and Math.Floor

2. Use the created Azure Function in your flow



New Member

Got the same question... And its 18 months later, is this still not possible?

Thank you for this blog, this is so helpful

@Roderick wrote:
Got the same question... And its 18 months later, is this still not possible?

@Roderick - It's always been possible. You just don't know how. 



This was very helpful, thank you. But I have a question about images stores in Sharepoint list. How could you pull back a random image?

Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,250)