Unanswered

MS Forms anonymous submission but need to capture where the form was completed

(1) Share

Report

Posted on by emberkrumwied

140

I have created an MS Form (a suggestion box) and set it to not record the submitters name or info. The form will be placed on various company SharePoint sites (different sites for different departments/locations) and we would like to at least record from which site the form response was submitted from. The aim would be to then direct the response to the internal contact assigned to the department/location from where the response was submitted from.

I have set up a Power Automate flow to capture the responses and add them to a SP list, but need a way to capture the site name of where the submission came from. So if the form was embedded into https://contoso.sharepoint.com/sites/my-team and a user submits a response, the flow would capture the "my-team" parameter and add that to the list with the response. We don't want to capture the name of the responder just identify from which site they completed the form.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

There is no way to embed data into a form and no way to capture where it was launched from if its set to be anonymous. Your only two choices are to add a question to the form for the submitter to pick where it was submitted from or to create a separate form and flow for each location. Each separate form would be for a specific department so the flow would know where it came from based on the form. Logic beyond the trigger could be kept in a child flow that is called by each specific department flow to minimize the upkeep.

----------------------------------------------------------------------------------
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 12,966 Super User 2025 Season 2 on at

Like (0)

Report
This is more a MS Forms question than it is about Power Automate, but fortunately to build flows you need to know so much about M365 for them to effectively work. Do this:

Open the MS Form as the editor.

Add a question to store the value (e.g., site).

Click the three dots to the far right next to the Present menu option and choose Get pre-filled URL from the menu.

Go to the question you added and enter the name of one of the sites.

Scroll to the bottom of the form and click on Get pre-filled link.

The link will look something like this: https://forms.office.com/Pages/ResponsePage.aspx?id=formid&questionid=MySite

Then for each site, update the highlighted portion of the URL with the appropriate site.

Then you need to have the respondents from each site use the URL for their site. When they click on the lick, it will populate the value into the question.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

@David_MA is correct. The Prefilled URL is evidently a new feature. This wasn't available in the past, but is the perfect solution for what you want to do now.

----------------------------------------------------------------------------------
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
Verified answer

emberkrumwied 140 on at

Like (0)

Report

@David_MA - appreciate the information, I was hoping to use embed the form into a SP Page (via a web part) to collect the responses. It sounds like your suggestion would require users to click on a link to respond. Additionally, the prefilled link that was generated did not follow the format you indicated:

https://forms.office.com/Pages/ResponsePage.aspx?id=[really long number letter combination was here]=residential. But it doesn't sound like this would be a solution for us at this time anyway.

@Pstork1 - thanks for the suggestion, was thinking that may be the way to go, but the maintenance of the forms and flows is a bit more than I'd really want to do. Will just go back to the department that requested this build and determine how important this component is to them.

Much appreciated to you both for your quick replies.

Was this reply helpful? Yes No
David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

The two options that @Pstork1 and I have listed are the only options you really have. So please add a reply to how you are going to handle this and mark it as the suggested answer, or mark one or both of our suggestions as the answer so that this post is closed. Good luck.

P.S. The link format you show is the same as what I showed. The URL generated contains the ID of the form and the ID of the question, which you refer to as "[really long number letter combination was here]."

Was this reply helpful? Yes No