Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Retrieving data from Microsoft Forms

(0) ShareShare
ReportReport
Posted on by 21
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
  • JamesJenkins Profile Picture
    JamesJenkins 21 on at
    Retrieving data from Microsoft Forms
    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?
  • Suggested answer
    David_MA Profile Picture
    David_MA 8,950 on at
    Retrieving data from Microsoft Forms
    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.
  • Suggested answer
    Pstork1 Profile Picture
    Pstork1 64,767 on at
    Retrieving data from Microsoft Forms
    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
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard