power automate
83 TopicsForms '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 connector611Views1like1CommentMicrosoft 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?66Views0likes1CommentForms
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.45Views0likes1CommentCapture 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. Thanks126Views0likes3CommentsMS 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)17KViews0likes7CommentsMicrosoft 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. Keith371Views0likes1CommentWeighted 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.127Views0likes3Comments"Allow respondents to edit their responses" does not fire flow trigger
New Option "Allow respondents to edit their responses" is added. https://www.microsoft.com/ja-jp/microsoft-365/roadmap?filters=&searchterms=124819 But flow doesn't fire when answer is edited and submitted. This makes no sense...Also test the connector, plz.8.4KViews0likes22CommentsValidating consent on MS Forms
I'm creating new forms which will capture children attending activities and needs to be approved by a parent. The old way was to have the parent sign and authorise participation. Can anyone in the community think of a way to do this with MS Forms which would meet legal requirements that a proper person has authorised the form instead of the child completing the form on behalf of the parent?455Views0likes4CommentsFind out in which language a form was submitted
Hello Community I've set up a Microsoft Forms in mutiple languages, so my user can choose the language in which he or she wishes to fill it out. After that, I want to automatically reach out to them with an email when they're done filling out the form. For that, I made a Microsoft Flow. Considering that my form is available in multiple languages is there a parameter that tells me in which language my user chose to fill out the form? So I can send them their mail in the correct language? Thanks in advance!2.2KViews0likes7Comments