cancel
Showing results for
Did you mean:
Memorable Member

## Does "@rand(1,2)" of Windows Definition Language return 1 to 2 with same Probability ?

I want to get a random number between 1 and 2 with same probability.

The rand(1,2) function of Windows Definition Language seems to return 1 only, not return 2.

My flow for "Up and Down"

Now I use rand(1,3) instead of rand(1,2)

Does rand(1,2) return between 1 and 2 with same probability ? or need rand(1, 3) for return between 1 and 2 ?

Regards,

Yoshihiro Kawabata

1 ACCEPTED SOLUTION

Accepted Solutions
Memorable Member

My result is that rand() function return first parameter value and 2nd parameter value -1.

In result does not include 2nd parameter.

My test:

@rand(1,10) result send Power BI Service streaming dataset per 1 minutes, 100 times.

and build a report the count of each result value.

I can know rand function return value of Windows Definition Language.

and I enjoy the cooperate between Microsoft Flow to Power BI Service streaming dataset .

Regards,

Yoshihiro Kawabata

9 REPLIES 9
Community Support

Hi Yoshihirok,

rand(1,2) should return 1 and 2. But I think rand(1,2) will only return integer right? My apologize for not quite familiar with Windows Definition Language.

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Memorable Member

In document

rand: "This is used to generate a random integer within the specified range"

https://docs.microsoft.com/en-us/rest/api/logic/definition-language

"rand" return integer.

but, there are no-probability description.

Regards,

Yoshihiro Kawabata

Memorable Member

30 times result of @rand(1,5) between 1 to 4, no 5.

Memorable Member

30 times result of @rand(1,5) between 1 to 4, no 5.

Memorable Member

30 times result of @rand(1,5) between 1 to 4, no 5.

Memorable Member

30 times result of @rand(1,5) between 1 to 4, no 5.

My test is that Add rand(1,5) result to Power BI Service Dataset per 1 minute dualing 30 minutes.

Regards,

Yoshihiro Kawabata

Memorable Member

My result is that rand() function return first parameter value and 2nd parameter value -1.

In result does not include 2nd parameter.

My test:

@rand(1,10) result send Power BI Service streaming dataset per 1 minutes, 100 times.

and build a report the count of each result value.

I can know rand function return value of Windows Definition Language.

and I enjoy the cooperate between Microsoft Flow to Power BI Service streaming dataset .

Regards,

Yoshihiro Kawabata

Anonymous
Not applicable

I am trying to use the rand function in my MS Flow to generate a random unique number id within the Assigned User ID section of the Create a Task Action. The file is read from MS forms and the task is being created as a card in MS Planner.

MS Flow explains rand as rand(minValue:integer, maxValue: integer), so I have tried the following in my flow:

`rand(1:int,10:int)`

but it keeps saying invalid expression.

Can you please advice how I can create a random unqiue number id using an expression within Assigned User ID tab for the Create a Task Action?

Many Thanks,

JB

Anonymous
Not applicable

I have created a Microsoft Flow that reads a MS Forms request and then creates a task card in MS Planner. For each request that comes in I would like to give it a random unique number so it can be tracked.

In my create a task section, the assigned user id can have an expression provided, which is where I have tried the rand function rand(1:int,10:int) but MS Flow has said that this is not a valid expression.

Can you please help me to write the rand expression correctly, so I can give each created task a random unique number id?

Kind Regards,

JB

The image below shows the MS Flow requirements for rand and where I am trying to write the expression

Announcements

#### Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

#### We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Top Solution Authors
Top Kudoed Authors
Users online (1,365)