Forum Discussion

Mr_Trust_A's avatar
Mr_Trust_A
Brass Contributor
Dec 09, 2023

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_Elliott's avatar
    Rob_Elliott
    Bronze 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)

Resources