Forum Discussion
Randomly Select Entries in your Sharpoint List for Review
I have a sharepoint list that is recording the lcoation of stock. Once a week or MOnth i would like power automate to randly choose 10 items in the list for review. They will use the list to capture ...
I used this: body('Get_items')?['value'][rand(0,length(body('Get_items')?['value']))]
But it only returns 1 item, can i change it somehow to recieve 5 random items?
But it only returns 1 item, can i change it somehow to recieve 5 random items?
Do an "Do until" you reach 10 and within that do until your stuff!
https://www.acuitytraining.co.uk/news-tips/power-automate-do-until/
https://www.acuitytraining.co.uk/news-tips/power-automate-do-until/