Retrieving data from Microsoft Forms

(0) Share

Report

Posted on by JamesJenkins

Hi,

I am trying to build a flow that retrieves account data, send an email to accounts based on filter criteria and sends them an email.

Within the email that gets sent to the account will be a link to a Microsoft Form, the purpose of the form is to collect data from the account that I want to resubmit back into Dataverse.

I have everything working apart from getting the response id back from Microsoft forms and updating the correct Dataverse row relating to that account.

I have tried prefilling the form with a field for the unique identifier, but I didn't want this to be editable by the user. I have also tried setting the form response id within the URL, but this doesn't seem to be working either.

Id someone could help that would be great, let me know if you need any more info/context.

Thanks,

James

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Pstork1 69,330 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Are you sending the form to internal or external users? If you are sending it to internal users just make sure not to set it for allow anonymous and the form will contain the email address of the submitter. Then you can use that to decide which row to update.

If you are sending the forms to anonymous external users there really isn't a way to do this. MS forms doesn't allow you to fill in information on the form before you send it so there is no way to include an ID other than having the user fill it in. If you are sending anonymously the best you can do is have the user fill in something like an email that you can use to track who submitted the form and use that to decide which row to update.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Suggested answer

David_MA 14,278 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

What you outline with the pre-filled value in the link is the way I would handle this. I don't think @Pstork1's suggestion will work since you say this is for account data, which I imagine is for your customers and they would then be external, and you cannot capture the e-mail address. If they are internal and you capture the e-mail address, you would then have to somehow associate the e-mail address with the account.

I have not tested this, but this might work with the pre-filled link approach. Add branching on the question, so that the question before it skips to the question after the one with the account number. This way the data will come back with the response and the recipient will not be able to change the value since it is skipped.

Was this reply helpful? Yes No
JamesJenkins 21 on at

Like (0)

Report
Copy link

Link copied!

Thank you everyone for your response.

The accounts are external but not anonymous. The email address of the submitter will be linked to a contact rather than an account - I will see if I can use this as the determining row factor.

The prefilled field I tried would still be editable by the user so this is not a route I would prefer to go down, I can't branch around this field because then it isn't captured in the response return.

EDIT - Just seen that I can't have the form open to people outside the organisation and have anonymous response off - so any other suggestions? Should I create a form inside a PowerApp and go that way?

Was this reply helpful? Yes No