How can i make sure i don't get the same item more than once when i use the Rand() function in Flow?
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.
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'.
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.