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?
Individual Response on Forms to be viewable to Approver
Hi! Currently our company would like to have a particular form filled up which will be send to a manager for approval, this manager may be changed from form to form (not static). My current flow would be fill up the form on forms, populate the data into sharepoint and manually input manager name for approval. However, I do not wish to have all the fields from the form into sharepoint columns as that would look really messy. I would like an option to either email the forms response along with the approval request or a separate window in sharepoint where the manager can view the response before approval. I can't seem to find a solution for this. Any advise / ideas would be greatly appreciated Thank you in advance!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.
Form Date extracting data to sharepoint using flow etc.
I have a form called "Report work dates" In this form i use the question type "dates" so the user can pick a date. Then i use Microsoft Flow to extract the data from the Form and us that data to input into a list in Sharepoint. But in sharepoint i must select a TEXT column in the list for the date to be imported to the list with Flow. I can not make the date from Forms go into a Date column in sharepoint. This means i can not populate a sharepoint calendar with a Form answer. This sucks!