Accessing Forms Quiz Score in Power Automate (Forms API, Sync)

(0) Share

Report

Posted on by Jawad

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.

Connector: Send an HTTP request to SharePoint

API: https://forms.office.com /formapi/DownloadExcelFile.ashx?formid=XXXX

Error: Required user login

{
  "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.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Jawad 2 on at

Like (0)

Report

It looks like setting up new SharePoint connection references fixes the problem.

Was this reply helpful? Yes No