Forum Discussion
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 int...
DingkunXie What is your source for this information?
DingkunXie
Microsoft
MicrosoftThis is how we implement it in our service.
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.
- I've had the same problem - working great for ages, then it's suddenly stopped working.
- It looks like setting up new SharePoint connection references fixes the problem.
