Is there any solution to getting question names yet for a form submission in Power Automate?
It's been about 10 years now. Surely there is a solution to dynamically retrieve question names without needing a janky britttle workaround that may or may not work, not just IDs (get form response etc), without having to rely on a hard coded list of questions with answers inserted in against them.
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...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!
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. Thanks
Microsoft Forms - Branching question
Hi all, I have just joined these forums and this is my first post. Is it possible to do the following with Microsoft Forms and if so, how?:- Create a form in Microsoft Forms with 4 multiple choice questions. Each answer/option for each of these questions has a number of points allocated to it, for example, option1 has 10 points, option2 has 20 points and option3 has 30 points etc. (See below) Question:- "What is the size of the audience for your in-house training?- Select one answer: Option1:- 100 - (10 points) Option2:- 500 - (20 points) Option3:- 2000 - (30 points) Option4:- 10,000 - (40 points) The user does NOT see how many points are allocated per possible answer and all the other questions are like this. Once the user has selected their respective answers, they are required to click a SUBMIT button at the bottom of the screen. Depending on how many points they have accumulated, they will see a different feedback screen, for example, if they have just "scored" 40 points, they will see the FIRST information/feedback screen with some text, a link and a graphic (if possible). If they have scored 60 points, they will see the SECOND information/feedback screen. This also applies if you get 80 or 100 points and you get different feedback depending on how many points you have "scored" as this form has a branching methodology with the form itself linking to 4 different screens or HTML pages with this feedback. Now million dollar question as before... Is this possible? If so, how can I do this and do I have to use some other kind of technology like Power Automate etc in conjunction with Microsoft Forms. I look forward to hearing from you. Thanks in advance. Keith
Weighted Answers in 2 Survey Pages adding up to a end value.
Hello there, new to MS Form and Power Automate so bear with me on this one: Part of an Ideas Survey, requires a user to complete a 'Survey Page' where there are 7 Questions with 4 possible choices. 1 Choice per Question, each Choice is weighted Option 1= 0 Option 2= 1 Option 3 = 2 Option 4 = 5 Once answered, should give a value of the sum of weighted answers... so 3 Question have option 3, 2 questions were answered option 2 and 2 were answered option 4. totaling 18 A second survey page very similar weighted options to the questions. What these values I would need to utilise to find a reference based on a Grid of Values. 1 to 35 along and 1 to 21 Up, the values in the survey would be used to gauge 18 cells along and , lets say 15 rows up. In that specific Cell would be a Reference. something like H15 a Formula would be something Like if Survey1 Value >15 then H, <=15 and >=10 then M, >=0 to <10 then L Then it would be to concat the value of the of that plus the Survey 2 Value. How, would I go about doing that? Just from messing about, it would have to be a triggered Power Automate to then add to a variable, then after that no idea. Anyone able to do this and to help with a step by step? Much appreciated. Mike.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?