Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Get Random Non Repeating items from SP using flow

How can i make sure i don't get the same item more than once when i use the Rand() function in Flow?

Super User II
Super User II

hi @marial16  I suppose that you are saving the random values into a column in sharepoint list, so you can use Filter Array to get only the values that are the same in your sharepoint list or list only the values that not.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!

If you want you can follow me at Quieres contenido en español? Síguenos en Power Automate LA


I dont save the rand values back in SP. 

My flow is an ask-respond to powerapps where i display the random, (questions) in my case ,that i get from flow.

But because it involves 10 questions, i get the same more than once in Powerapps.

@marial16 a truly random selection will result in bringing back the same item more than once, particularly if you have a list of only 10 items. You would need an extra column (called something like Random) in your SharePoint list which would get updated in the flow to "Selected" after the item is returned. Then your filter query in the Get items actions would need to be Random ne 'Selected'.

Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,503)