Forum Discussion
Mr_Trust_A
Dec 09, 2023Brass Contributor
Create fixed random numbers in SharePoint list
Unfortunately, in SharePoint Online, there is currently no out-of-the-box solution to generate a random number that remains fixed without changing after editing the list item using only calculated columns. Calculated columns rely on the values of other columns or system functions like NOW(), which update automatically. It would definitely be ideal if Microsoft can add this feature to SharePoint Modern experience.
I am aware of alternative ways like using SharePoint Designer to create a custom workflow or use Power Automate flow. But these are complex solutions for normal users.
Please upvote this idea here if you like it: Create fixed random numbers in SharePoint list ยท Community (microsoft.com)
Thanks,
- Rob_ElliottBronze Contributor
Mr_Trust_A you can't use SharePoint Designer with SharePoint Online. Power Automate can generate a random number quite easily via a JSON-formatted button in your list.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP (and classic 1967 Morris Traveller driver)- Mr_Trust_ABrass ContributorThanks!