Auto generating unique ID in Power apps and Microsoft Forms

Question

I am tasked in developing a form which is going to record and store data into a SharePoint list (Office 365 online SharePoint) So far I have been looking into two different methods I am not sure if they are suitable given the requirements of the work scope. The requirement is that each form has to be assigned to a unique ID/serial number and the data in the form has to be passed to a SharePoint list.

The first method that I have looked at is using Microsoft Forms to be the online form to collect the data and Power Automate to get the data and put it into a SharePoint list. The problem is I do not know if there is a way to assign a unique ID on the form itself before submitting the form. Is there a way or method where I can autogenerate a unique ID/serial number on a form before submitting it ?

I am also looking at using PowerApps to create a form which will be linked to the SharePoint list. Is there a way to autogenerate a unique ID/serial number and prepopulate it on the form?

Answer 1

I don't know how to set the "language" in the NumeralTickFormatter but you can make use of the CustomJSHover and create you own rule with a few lines.

Minimal Example

from bokeh.plotting import figure, output_notebook, show
from bokeh.models import HoverTool, CustomJSHover
output_notebook()

p = figure(plot_width=400, plot_height=400, title=None)
x = [999.5, 1000.7, 1001.0]
y = [2, 5, 3]
p.circle(x, y, size=10)
custom = CustomJSHover(code=
    '''
    var num =  special_vars.x.toFixed(2).toString()
    var splitted = num.split(".")
    for (var i=splitted[0].length-3; 0<i; i-=3){
      num = num.slice(0,i)+" "+num.slice(i)
    }
    return num
    ''')

p.add_tools(HoverTool(
    tooltips=[('x','$x{custom}' )],
    formatters={'$x':custom}
))

show(p)

Output