Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Shuffle or Randomise items and create a HTML table

(0) ShareShare
ReportReport
Posted on by 4

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.

 

  • v-bofeng-msft Profile Picture
    on at
    Re: Shuffle or Randomise items and create a HTML table

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow