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

[SteCoxy]

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: 

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:

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?

[creativeopinion]

@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. 

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]

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]

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

[SteCoxy]

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. 

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?