Power Platform CommunityForums Power Automate - Building Flows Accessing Forms Quiz S...

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:

Business Process Flows

All responses (1)

Answers (0)

Suggested answer

Jawad 2 on at

Like (0)

Report

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

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