Forum Discussion
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.
3 Replies
- IanYatesMECCopper Contributor
jawadahmed I am also having this problem with Flows that worked perfectly before using API calls to get Form information but now fail. I can't find anything regarding an API change or any other information from Microsoft on this. Please let me know if you find the solution!
- jawadahmedCopper ContributorIt looks like setting up new SharePoint connection references fixes the problem.
- jawadahmedCopper ContributorExactly! I have also posted a question in power platform community.
https://community.powerplatform.com/forums/thread/details/?threadid=cfb09a76-455a-ef11-a317-0022482822d9