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?
Conditional Form Questions - For multiple answers in a "choice" question type
Hi I've been trying to find a way to have nested conditional questions in a form so only appropriate questions are being asked based on previous responses. (It doesn't look like branching is the answer to this situation) I have the following question in a form; What I'm trying to achieve here is when a responder selects option 1, a new section of questions appears for them to fill out. If more than 1 option is selected, then a set of questions should appear for each response (but should not be shown if the option is not selected). For example, in the image below, this section should only show up if option 1 in the above question is true/selected, then questions 6&7 should only appear if their respective response in question 5 is selected. The output from this form will be piped into a power automate flow and therefore we want finer granularity in the questions. If this is currently doable, can someone please enlighten me? If this isn't currently doable, can someone please tell me a good way of submitting this as a feature request as I think it would make Forms a much more powerful tool?
New Form Submissions not Pulling to Power Automate
I have form submissions set up to trigger a Power Automate flow and the flow has suddenly stopped working after years of use. Here are a couple things I have noticed in my troubleshooting: It seems that somehow not all new form submissions are being registered by MS Forms. When I look at the number of responses on the Form Responses tab, there are several missing compared to the number when I open the responses in Excel (1146 compared to 1158+). I have entered a subsequent form ID (1160) into my flow and the flow was successful. This was the original flow: Any insight that can be offered is much appreciated. Thanks!Accessing Quiz Score in Power Automate (Forms API, Sync)
We've been utilizing the Forms API to download the Excel file and retrieve user scores in Power Automate, since the standard response (Get Response Details) connection doesn't provide the user's score. Lately, we've faced issues with this API; it used to operate with Power Automate but hasn't been working for the past week. Connection: Send an HTTP request to SharePoint { "status": 401, "message": "{"error":{"code":"701","message":"Required user login."}", "source": "https://forms.office.com/formapi/DownloadExcelFile.ashx?formid=XXXXXXX", "errors": [] } We attempted to use the Forms synchronized Excel file from SharePoint, but it only updates with the actual form data when accessed through a browser.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.
Customer Voice (Forms) reverted to sending from default instead of custom email
Is anyone able to help please? Our Customer Voice surveys are sending via Power Automate and it has changed this week to send from the default <email address removed for privacy reasons> instead of our customer email <email address removed for privacy reasons>. The Distribution Settings in Customer Voice is still correct, but it is sending from Forms email instead. We were due to send to 1,500 survey yesterday and need it to send from our own email, so if students reply to emails they don't go to <email address removed for privacy reasons>. I will consider any work arounds. 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 connectorPower Automate, get Form Name in Sharepoint List
Hello, I want to make a flow to send to a list in sharepoint the responses of my flow. In this sharepoint list, I would like to have also a column for the flow name, which I don't know how to get. Can somebody help me with it ? Thank you in advance. Bellow a print screen of my flow:
