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.
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. Read More