Combine Multiple MS Forms into one SharePoint List via Flow
Hello, I am trying to create a workflow for new hire requests. The HR Admin will enter a request via a MS Form and those responses will create a list item in SharePoint and also send an email to the hiring manager. The hiring manager will be prompted to enter additional information via a Mgr MS Form. The HM responses will then update the previous list item created by the HR Admin. All responses will then be sent to a distribution list for further action. I have created both forms, the Sharepoint list and have created multiple flows, however, the Manager Form responses are not updating to previously created HR items. It is creating a new item instead. The flow is below. Any suggestions? I am new to Flow and have been You Tubing and Googling to learn!
Send approval to the right manager
Hi! I want to be able to create a flow that looks like this: Microsoft forms (example order computer from forms admin account) > Approval (closest manager needs to approve, found in office 365(?)) > if approved, mail sent to me for ordering of new computer. I'm very new to flow and have tried some ways but could not get it to work.
Query Forms API to get scores or results from form submission
Hello All, May be one for the Forms/Dev Community but thought I would try here. We have a process where 4 forms are submitted weekly (Every week has 4 new forms). We currently gather responses into a SPO list and feed that in PowerBI. A new requirement has come in that the forms (which are quizzes) also need to push the scores to SPO. We have done this with conditionals to check the text of the correct answers but the workload for this is unmanageable. I know there is a forms Api (undocumented) and we have successfully queried it to get the quiz questions, but these doesn't seem to be any info in there about the right answer. My question is, is it possible to query the forms API to get the response points, either total or per question? Included is the starting point, just need to know if anyone knows the URI to get what we need.
Customising microsoft form submit button to do a specific action
Hi people, Very new to Microsoft Forms so please bear with me. Is there any technology I can use to make a Microsoft Form submit button to do something specific? The form will have a number of categories people click on (e.g. option 1, option 2 etc). When they submit, I would like put in a mechanism in place so that the responses get submitted to an email address with the subject line starting with "option 1..." or "option 2..." depending on what the user has selected. Is that even possible? Any help would be much appreciated.... many thanks in advance 🙂"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.Increment score based on responses using Power Automate
Hello, I have created a form using Microsoft Forms that asks a user a few questions. I am using power automate to assign a value to each response based on what the user selects, and at the end, once they submit the form the score is accumulated and stored in a sharepoint list. The problem is, each answer has a different score attributed to it, and it does not seem to be adding them correctly. To make the flow easier, I made conditions based on the points (1-5), as shown below as an example: I am also attaching the scoring formula I am intending on using: The problem as stated is that the scores never add up correctly. If I am selecting more than one three point question in different sections or even the same, it doesn't add it all and I instead get a lower score than I should be. I don't want to have to create a bunch of conditions (that seems to be the only solution) so is there something wrong with the logic or is there an alternative? Thanks in advance.
Updating column in SharePoint List row using forms submitted by different users
I'm a novice at PowerAutomate. I've built two Forms. First will go to a student. Student fills out information including a school official email address. Once submitted, one Flow will use the school official email address to send a form to the school official. A second flow will load information into a SharePoint List. Both forms (student and school official) ask for a student ID number. When the school official submits their form I'd like to build a Flow that updates the row submitted via the student's form with select information from the school official. Ideally, I'd be able to use the student ID (StarID) in the Flow to connect everything (ie if the StarID is the same please do this . . .). The only data that I want added to the student row is the recommendation (far right column of screenshot). School Officials will recommend "Yes" or "No." All other data you can see in the screenshot is loaded in when the student submits their form. After the school official submits, the flow would look to see if there is a StarID in the list and only add the data from the recommendation. Any help would be more than appreciated.
