Feature Request – Read-only and Locked Fields for Pre-filled Microsoft Forms
Microsoft Forms has recently introduced support for pre-filled responses, which is a very valuable addition. However, the lack of read-only fields significantly limits its usability in real-world and enterprise application scenarios. In many workflows, especially those involving bots, kiosks, or guided user interactions, some fields must be pre-populated with system-generated data such as user identity, email, or contextual information. These fields need to remain visible to the user for transparency, but must not be editable in order to guarantee data integrity and prevent tampering. Currently, there is no reliable way to enforce this behavior. Even when using pre-filled URLs, users can still modify the values before submission. This creates a risk of data inconsistency and makes it difficult to maintain a secure and synchronized interaction between the client and backend systems. This is not just a UX limitation, but also a data integrity issue in integrated workflows. As a result, developers are forced to implement server-side validation and ignore user-provided values for critical fields, which defeats the purpose of pre-filling them in the first place. This forces developers to rely entirely on server-side validation, reducing the effectiveness of pre-filled data and introducing unnecessary complexity. While Power Apps can address this limitation, it is often too complex and heavy for simple scenarios where Microsoft Forms would otherwise be perfectly adequate. Suggested improvement: - Allow form fields to be marked as read-only or locked - Optionally support hidden or system fields - Allow pre-filled values to be protected against tampering - Preserve compatibility with pre-filled URLs This feature would enable Microsoft Forms to be used in secure, system-driven workflows without requiring migration to more complex platforms.
Power Automate not pulling all form answers
I have a flow that triggers fine using the "When a new response is submitted" but the "Get response details" is only returning a few of the answers submitted. I can see the full submission the the back end of forms but Power Automate is not pulling a lot of the submitted answers. It has worked fine for 50 times, the automation is long and complex so if possible id like to stay away from deleting and restoring the trigger and get response details...
Generating an email with Power Automate using data from MS Forms
I'm trying to generate an email based on responses to a Microsoft Form. To do that, we've been using Power Automate. But I don't know coding, so I'm struggling with the "if this, then do this or if this then do this." I'm trying to add content based on the response to a form question. This is what I have & Power Automate doesn't like it. If possible, I want the No response to result in a blank. if(equals(outputs('Get_response_details')?['body/r4dc7982d2d21447595928fe605d196a9'],'Yes','SNAP',' ') It also doesn't like this: if(equals(@{outputs('Get_response_details')?['body/rfa090ef4e8d14bf187d32d6ee29bce37']},Yes),'What is needed to complete the benefit request? @{outputs('Get_response_details')?['body/r6671aa148c974fbfb399bdf3c334f4a4']}',' ')
Excel Does Not Sync Until Opened
I created a form linked to an Excel spreadsheet in SharePoint as well as a Power Automate approval flow triggered on submission. In addition to sending out confirmation/approval emails, the flow also updates the associated Excel spreadsheet with the approval/denial. The flow was working fine until last week but since then has failed 2 consecutive times. The failures appear to be related to the flow unable to find the automatically generated submission ID in the Excel spreadsheet. When I open the linked spreadsheet, the submission is not immediately present at first but the file does sync at that point and the entry appears. When re-triggered after the sync, the flow completes successfully. Not sure if it is related, but MS form/linked spreadsheets have been updated by Microsoft recently and I was prompted to go through an update process for synced Excel spreadsheets. I completed the update with this specific form last week after the flow failed for the first time. TLDR - my form only syncs with the spreadsheet once opened. Any ideas how to get MS Forms to update the spreadsheet in real-time as opposed to when it is opened?Resubmitted response overrides original response instead of making a new entry
Hi, I have a Microsoft Form that allows respondents to edit their submissions after submitting. Last week when someone resubmitted their response, it created a new entry in the Excel sheet which is what I prefer since it triggered a Power Automate flow. However, I ran it again this week and now it seems to override the original response in the Excel sheet. This does not trigger the flow, which is a big issue. Does anyone know why this might be happening/how to fix it? Thanks in advance!
Forms 'Get response deatails' PowerAutomate connector return 'points'
Hi guys, we use Forms in combination with PowerAutomate to realize a training assessment for users. Every user who completes the assessment and gets sufficient points will get automatically granted additionally permissions in the system. BUT as the 'Get response details' PowerAutomate connector does not return the points which the user reached or the amount of correct answered questions, I need to compare each given answer with what is correct. This is very error prone and duplicates basically the Form logic in PowerAutomate. Please return the amount of points in the 'Get response deatails' PowerAutomate connector
Microsoft Forms: Multiple Choice Type is not showing all answers in SharePoint List
Hi, I have created a Microsoft form which contains a field "Pemohon". This field is a VLOOKUP of the type "Multiple Choice". The entries submitted in this form are reflected in the SharePoint list. After submitting the form, the multiple choices entered in the field are not visible in the SharePoint list. Only the first choice among the multiple entries is visible in the List under that field. Even if I edit the entries in the SharePoint list it is still not showing the multiple entries in that field. Is this a bug? or am I doing anything wrong? Anyone else facing this same issue?Forms
I was looking and all I found were similar questions from as far back as 2019, so assuming no solution has been made, yet? Is any way to get a Form to read/populate dynamic choices for a question from an external source say a SharePoint online list? This would make it easier to manage the list without having to update the form each time new options were added. For example, if I had a form with a question asking for a person to assign that day to that task and the list of people available to pick from changes daily (but is scheduled a month in advance with potential last minute tweaks), I would rather pull a list from a common external source than have to update the form each day or any time a person switches days.Capture Edited Form Submission
Hello. I have created a Power automate to capture the response when a form is submitted. We allow the users to edit the from after submission, sometimes they don't have all the info at first submission. Does anyone know how to capture the resubmission of the form after the user edits it. The Excel sheet that the form is linked to does get updated with the resubmission but I cannot use this to trigger an alert for the edit. I am trying to avoid linking the form to Sharepoint list just to capture the change. Ideally I would like to trigger a workflow directly from the resubmission of the form. ThanksMS Forms Weighted
We have various surveys that we send to client using an external survey provider. I am investigating the ability to satisfy our needs by using MS Forms. One requirement we have is the ability to have a weighting tied to our questions as I have specified below. We would like to capture the scoring value in the Excel document behind the Form for easy tabulation. Can someone guide me as the whether this is possible? Thanks. Question: How was the quality of service you received? 1. Superior (worth 100) 2. Good (worth 80) 3. Average (worth 60) 4. Poor (worth 40) 5. Terrible (worth 0)