web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extract random value f...
Power Automate
Answered

Extract random value from variable

(0) ShareShare
ReportReport
Posted on by 38

Hi experts,

I'm beginner to PAD

 

variable with a set of values, I want to choose a random one

Снимок.PNG

I have the same question (0)
  • Verified answer
    Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    Could you try to add the below actions in your flow and test it. (using display to see the output)

    Kaif_Siddique_0-1678562638688.png

     

    Kaif_Siddique_1-1678562756096.png

     

    Kaif_Siddique_2-1678562864815.png

     

    Let me know if this works.

  • hadz Profile Picture
    8 on at

    Thanks a lot, It works.

     

    11.png

  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    If I have answered your question, please mark my post as Solved.

  • hadz Profile Picture
    8 on at

    Thread closed, thanks again!
    Please explain the line %Bing_Link[RandomNumber][0]%
    Why does the second parenthesis with [0]?

    Work without this parameter.

  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    To retrieve a specific item of a datatable, use the following notation: %VariableName[RowNumber][ColumnNumber]%. Keep in mind that the RowNumber and the ColumnNumber should be 0 for the first item (row or column).

     

    %VariableName[RowNumber][ColumnNumber]% --> %Bing_Link[RandomNumber][0]%

     

    Refer this link:

    https://learn.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#datatable

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard