cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DiogoJusto
Level: Powered On

Microsoft Forms Unique ID

Hi,

 

I have a flow getting the response details of a MS Forms and write in a sharepoint.

 

The problem is with the box "When a new response is submitted" because the field "responseId" is generating duplicates as you can see on the images.

image.png

 
 

image.png

 

image.png

 

 

Anyone had the some problem? Is this a bug that needs to be fixed?

 

The flow that I use is this one:
image.png

 

 

Thanks,

Diogo Justo

9 REPLIES 9
Highlighted
InterestedBloke
Level: Powered On

Re: Microsoft Forms Unique ID

Silly question, but just to check - are these completely new entries to the Forms or are you testing the flow over and over again with the same input?

Super User
Super User

Re: Microsoft Forms Unique ID

Hi @DiogoJusto 

 

Can you please upload the Power Automation? The image is missing. Probably this can provide some insight on what could be happening. 

 

Do you have a lot of people filling in the form at the same time? The event time is the same down to the millisecond, so that's why I'm asking. The probability of that happening is low, but since the dates are the same, The system that generates IDs probably doesn't handle these race conditions correctly.

 

Makes sense?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

DiogoJusto
Level: Powered On

Re: Microsoft Forms Unique ID

These are completly new entries, before putting the Flow in Production I made several tests and this never happened.

DiogoJusto
Level: Powered On

Re: Microsoft Forms Unique ID

Hi @manuelstgomes ,

 

I edited the post and uploaded the image.

 

Usually 2/3 persons a day, once the process is quite "simple" because we only need to use the blocks "When a new response is submitted" and "Get reponse details" I don't understand what I have to do in order to solve this issue.

 

Thanks,

Diogo Justo

Super User
Super User

Re: Microsoft Forms Unique ID

Hi @DiogoJusto 

 

I was checking your Power Automation and I think I found the issue.

 

You don't need to put your Power Automation in a "Apply to each". This Power Automation will trigger for each reply posted since it's a "Trigger when A new response is submitted", so if there are 2/3 per day it will trigger 2/3 times per day.

 

Try putting all outside the loop and see if the issue disappears. 

 

Please let me know if this solves the issue. If not we'll dig further to figure this out.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

DiogoJusto
Level: Powered On

Re: Microsoft Forms Unique ID

Hi @manuelstgomes ,

 

When I put the "List if response notifications Response ID" on the field Response ID, automatically generates a "Apply to each".

The problem need to be before, because on the screenshots that I've sent before you can see in the block "When a new reponse is submitted the field "responseID" already has duplicates.

 

image.png

 

Super User
Super User

Re: Microsoft Forms Unique ID

Hi @DiogoJusto 

 

Yeah, indeed, you're right. I'm still wondering why it puts the for each, but let's put that aside.

 

Honestly, this is so strange that it can only be a bug. If the actual trigger gets duplicate values, then it's something wrong in the Form generation itself.

 

Probably you need to submit this back to Microsoft to check and fix it.

 

I hope this helps you.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Community Support Team
Community Support Team

Re: Microsoft Forms Unique ID

Hi @DiogoJusto,

 

Do you still has the issue with the Microsoft Form trigger?

Does this happen often or occasionally? What's the frequency? I'm sorry, I was not reproduce it. If possible, you can recreate a new connection and try again.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

Re: Microsoft Forms Unique ID

Hey @DiogoJusto @manuelstgomes 

I don' think this should be in an 'Apply to each' loop... the loop shouldn't be automatically created?... it isn't for me:

1.pngHTH

Jay

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,200)