Unanswered

Get random item from a list

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(1)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PaulKeijzers1 on at

Like
a
(1)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

Thank you for this blog, this is so helpful

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

Like
a
(0)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

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