sharepoint-onlinepowerappsoffice365-appspowerapps-formulamicrosoft-forms

Auto generating unique ID in Power apps and Microsoft Forms


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?


Solution

  • The most flexible, customizable solution would be PowerApps

    PowerApps will connect directly to Sharepoint as a data source. There is most definitely a way to autogenerate a unique ID/serial number in PowerApps. Look into the GUID() function.

    Some great use cases for Microsoft Forms include:

    Each Microsoft Form submitted also has an ID (Response ID)... enter image description here

    But it is not suitable as a GUID/serial number. You could add one in Power Automate, using the guid() expression before creating the record in Sharepoint: enter image description here

    The entire workflow ends up looking like this: enter image description here