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!
Error importing Project Accelerator for Project on the web in power apps
I want to import the Project Accelerator solution for Project for the web (Project Plan 3). The solution can be downloaded form github https://github.com/OfficeDev/Project-Accelerator I am using a 30 day free trial version of M365 Business premium and Project planner premium with Project Plan 3. The suggested method to install the solution (as per above github repo Maintained by microsoft) is using http://powerapps.com > solutions > import solution upload the zip file download from the github page. I have global admin rights and using the default environment, and Rights to create Power Automate flows using the Common Data Service connector. However, when I get the following error message Solution "Project for the web Accelerator" failed to import: OptionSets import: FAILURE: SecLib::CheckPrivilege failed. User: XXXXXXXXX-XXXXX-XXXXXX, PrivilegeName: prvCreateOptionSet, PrivilegeId: XXXX-XXXX-XXXXX Required Depth: Basic, BusinessUnitId: XXXXX-XXXXXX--XXXXXX, MetadataCache Privileges Count: 5443, User Privileges Count: 1632 I am login in as the global administrator so all permissions must be already in place. In the Power Platform Admin Center, Environments > Settings > Users + Permissions > Security Roles and checked the user's assigned roles. All seems ok. Any help will be most useful.Extend M365 Archive Quota capacity
In my organization, we are currently on the O365 E5 License with default 100GB mailbox size per user and 1.5TB archive quota. However, due to organizational policy and regulatory requirements, we are expected to keep all the data from inception. Hence, the requirement for a solution to extend our archive size from 1.5TB. From the official Microsoft documentation, https://learn.microsoft.com/en-us/office365/servicedescriptions/exchange-online-archiving-service-description/exchange-online-archiving-service-description#archive-storage-quota the maximum expansion of the archive mailbox is 1.5TB. Is it possible to extend the archive storage to an Azure blob? Like an automated script that moves the data from the Archive mailbox for each user to the Azure blob or any other storage service that does not have storage size limitation. I am open to suggestions. Thanks
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.