Strategies for Associating Microsoft Form Responses with UID in Power Automate

[Darack]

Hello Power Automate Community,

I'm working on a workflow where a customer fills out a Microsoft Form, and this triggers an Adobe Sign process that generates a unique agreement ID (UID). After the Adobe Sign process is completed, the customer receives an email with a link to a second Microsoft Form that they need to fill out. This second form should be linked back to their specific Adobe Sign agreement using the UID.

Here's the challenge: I need a reliable method to ensure that when the second form is submitted, it can be associated with the correct Adobe Sign agreement ID. The UID is included in the email to the customer, but I'm unsure how to effectively capture this UID in the second form's response and use it in Power Automate to link the form submission to the Adobe Sign agreement.

The main questions are:

1. How can I ensure the UID provided in the email is accurately captured in the second Microsoft Form's response?
2. What's the best approach in Power Automate to link this form response to the corresponding Adobe Sign agreement using the UID?

I've considered manually adding a field for the UID in the second form and instructing the user to copy and paste the UID from the email. However, I'm concerned about potential user errors and the efficiency of this method. Is there a more automated or foolproof method to achieve this linkage within Power Automate?

Any insights, experiences, or suggestions on how to tackle this would be greatly appreciated. Thank you in advance for your help!

[RobElliott · Accepted solution]

@Darack what you want to do is not possible with Microsoft Forms as it is a simple one-pass submission only and it can't add pre-populated data or be associated to any previous form or other dynamic data. For your second question you would need to ask the responder to enter the UID manually into an answer.

Rob
Los Gallardos
Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)