Forum Discussion
Query Forms API to get scores or results from form submission
Any idea on how to access this API using Power Automate? Recently, we've encountered problems with this API; it used to work with Power Automate but has not been functioning for the past week.
Connection: Send an HTTP request to SharePoint
{
"status": 401,
"message": "{\"error\":{\"code\":\"701\",\"message\":\"Required user login.\"}}\r\nclientRequestId: xxxxx",
"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.
- It looks like setting up new SharePoint connection references fixes the problem.
jawadahmed My flow suddenly stopped working, it breaks at the HTTP Get block with the static forms excel link. I re-added the sharpoint connection and it still doesn't work. Does anyone know what changes Microsoft made to break this?
- This stopped working again yesterday and setting up new connections hasn't worked this time.
- Ah, that's brilliant, such a simple solution - it worked. Many thanks.
