Unanswered

Get random item from a list

(1) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Using connectors

I have the same question (0)

All responses (8)

Answers (0)

v-yamao-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Perumal 604 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Roderick 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
PaulKeijzers1 on at

Like (1)

Report

I created a blog with the solution to this problem https://sharepoint-specialist.nu/how-to-get-random-item-from-a-collection-using-microsoft-flow-to-post-a-message-to-twitter-teams-534c3265495e

Was this reply helpful? Yes No
MarkKemish 3 on at

Like (0)

Report

Thank you for this blog, this is so helpful

Was this reply helpful? Yes No
mandy-facts 2 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Bigshow 60 on at

Like (0)

Report

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?

Was this reply helpful? Yes No