Hi Everyone,
I have a SharePoint list of Staff names which I would like to shuffle and create an HTML table and then hopefully post this in a Teams chat. I am a bit lost on how to shuffle/randomize the Staff name so every time the flow runs it gets the items from the list then reshuffles them and add them to the HTML table. The goal is to have the order of Staff names different in the HTML table.
Any help will really be appreciated.
Hi @Zeera721 ,
Power Automate does not have a random sorting function. The method I use is to randomly intercept the array multiple times and recombine it to achieve a function similar to random sorting.
I think this link will help you a lot:
Solved: Split SharePoint list by flow - Power Platform Community (microsoft.com)
Best Regards,
Bof
WarrenBelz
146,651
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional