cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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?

 

 

7 REPLIES 7
Highlighted
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.
Highlighted
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.

Highlighted
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

 

 

Highlighted
New Member

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

Highlighted

Thank you for this blog, this is so helpful

Highlighted


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

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Users online (11,557)