cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Get random item from a list

Hello,

 

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?

 

 

8 REPLIES 8
v-yamao-msft
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.
Anonymous
Not applicable

Hello,

 

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.

Perumal
Continued Contributor
Continued Contributor

There won't be a simple way to do this. You can use Azure functions to achieve it(Ref: https://blogs.msdn.microsoft.com/carlosag/2016/05/10/using-an-azure-function-in-a-microsoft-flow/). You can use Math.Random and Math.Floor to generate a random value between a given range(Ref: http://www.w3schools.com/jsref/jsref_random.asp).

 

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

2. Use the created Azure Function in your flow

 

 

Roderick
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

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Kudoed Authors
Users online (5,326)