web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Generating a unique ID...
Power Automate
Unanswered

Generating a unique ID flow has failed and is now out of sync

(0) ShareShare
ReportReport
Posted on by 48

Hello, I have set up a solution utilising MS Forms, MS Lists and PowerAutomate that sends the data from the forms to the lists using a number of flows to do so. In addition, there's a flow that generates a unique ID (based upon the row ID of the list where the data from the form feeds into) and then sends an email to the submitter with this unique ID. 

 

This morning, I received an email to advise the flow had failed. When I've checked it's the flow relating to the generation of the unique ID that has failed: 

Screenshot 2024-04-16 at 12.08.10.png

 

The error details advise: 

Cannot complete this action.

Please try again.
clientRequestId: cc9a1880-28b5-4384-9b6a-7081603423b0
serviceRequestId: cc9a1880-28b5-4384-9b6a-7081603423b0

 

I was able to resubmit the flow and it appeared to have then processed as normal, but when I've checked the list where the data feeds into it's apparent there's a glitch:

SteCoxy_0-1713265853255.png

The unique ID is missing from row 816.. it should have been DI00816, but is missing on this row and instead has been applied to row 817, so is now out of sync by 1.

 

I'm wondering if there's a quick fix to getting the flow back in sync?

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @SteCoxy Can you share a screenshot of your flow? If you are using the new designer, please switch to the Classic Designer and click each action to expand and take a screenshot of your flow in edit mode. 

     

    In addition to your unique ID missing, you should be parsing your multi-choice selections. 

    creativeopinion_0-1713277956497.png

     

    I cover how to do that in this tutorial: How to Get a Microsoft Form RSVP Response into a SharePoint List

     

    IN THIS VIDEO:

    ✅ How to get a Microsoft Form Response into SharePoint

    ✅ How to get a Microsoft Form ID

    ✅ How to get a Microsoft Form response

    ✅ How to Build a Microsoft Form with Conditional Fields

    ✅ How to used Branching in Microsoft Forms

    ✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

    ✅ How to parse a Microsoft Form multiple choice response as string of text

    ✅ How to convert a text response to a number

    ✅ How to use the Switch action

    ✅ How to create a custom email confirmation for a Microsoft Form submission

    ✅ How to Create a Custom View in a SharePoint list

    ✅ How to use the Compose Action

    ✅ How to write Power Automate Expressions

     

    ----

    You might also be interested in this tutorial: How to Get Microsoft Form File Uploads Attached to an Email 📧

     

    In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.

     

    IN THIS VIDEO:

    ‌✅‌ Two types of MS Forms

    ‌✅‌ Where Microsoft Personal (OneDrive) Form File Uploads are Saved

    ‌✅‌ Where Microsoft Group Form File Uploads are Saved

    ‌✅‌ How to Add a File Upload Question to an MS Form

    ‌✅‌ How to get a Microsoft Form ID

    ‌✅‌ How to get a Microsoft Form Response

    ‌✅‌ How to Get the Dynamic Content Microsoft Form File Upload Content

    ‌✅‌ How to handle Single and Multiple Microsoft Form File Uploads

    ‌✅‌ How to use a Scope action to Organize and Group Your Flow Actions

    ‌✅‌ How to Get the File Content from an MS Form File Upload

    ‌✅‌ How to Collect All Files Uploaded to a MS Form and Attach to an Email

    ‌✅‌ How to Handle MS Form Response When a File Isn’t Uploaded

    ‌✅‌ How to Create an Email Key

    ‌✅‌ How to Send an Email to a Specific Recipient Based on Form Selection

    ‌✅‌ How to Create a Dynamic Output Based on Form Selection

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
  • SteCoxy Profile Picture
    48 on at

    Hi @creativeopinion, thank you for replying and reviewing my query.

     

    Thankfully, as if by magic, this seems to have correct itself with the next submission that has been made. 

     

    We've hypothesised that it could have occured due to there being multiple forms and flows that feed into the 1x MS List, but then 1x flow that creates the unique ID, so if different submitters fill in the forms around the same time it could be causing the flows to crash. 

  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @SteCoxy No worries. Were you able to sort out how to parse your multi-choice options?

    creativeopinion_0-1713365570957.png

     

  • SteCoxy Profile Picture
    48 on at

    I did, but I've got a feeling it's probably not the most efficient or neat.

     

    I simply mapped it from the form to the column in the MS List that I wanted it to go into. 

     

    Screenshot 2024-04-17 at 16.00.30.png

     

    Is there a way of enhancing this for them to appear separately and colour coded (like below in the choices column values), rather than bunched together and separated by commas?

    Screenshot 2024-04-17 at 16.01.33.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard