Views:

Applies to Product - Power Automate


What’s happening?
Customers are experiencing difficulties in generating a unique ID for each submission made through Microsoft Forms using Power Automate (Flows).


Reason:
The underlying cause of this is related to the configuration of the flow in Power Automate, specifically in setting up the actions to generate and store a unique identifier for each form submission.


Resolution:
To generate a unique ID for each Microsoft Forms submission using Power Automate, follow these steps:

  1. Create a Form: Start by creating your form in Microsoft Forms.
  2. Set Up a Flow in Power Automate:
  3. Go to Power Automate and create a new flow.
  4. Choose the trigger “When a new response is submitted” and select your form.
  5. Get Response Details:
  6. Add the action “Get response details” and select your form and the response ID.
  7. Generate a Unique ID:
  8. Use the guid() function to generate a unique identifier. This can be done by adding a “Compose” action and setting the input to guid().
  9. Store the Unique ID:
  10. Add an action to store the form response and the unique ID in a data source like SharePoint, Excel, or a database. For example, if using SharePoint, add the action “Create item” and include the unique ID in one of the columns.
Here’s a simple example of how the flow might look: - Trigger: When a new response is submitted. - Action: Get response details. - Action: Compose (with guid() to generate the unique ID). - Action: Create item in SharePoint (or another data source) with the form response and unique ID.