cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joef Post Patron
Post Patron

specify number of digits returned Rand()

Hi All,

I am using Rand() to set a pin for every record entered into  an SPO list.

It seems to be giving 8 or 9 digits to the right of a decimal point.

ex 0.12345678

Is there a way to tell it to randomly give me a 7 digit integer?

 

TIA,

Joe

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: specify number of digits returned Rand()

@joef 

Like this...

Round(Rand(), 7) * Power(10, 7)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

Re: specify number of digits returned Rand()

@joef 

Like this...

Round(Rand(), 7) * Power(10, 7)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

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