Forum Discussion

jawadahmed's avatar
jawadahmed
Copper Contributor
Aug 13, 2024

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

  • IanYatesMEC's avatar
    IanYatesMEC
    Copper 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!

    • jawadahmed's avatar
      jawadahmed
      Copper Contributor
      It looks like setting up new SharePoint connection references fixes the problem.
    • jawadahmed's avatar
      jawadahmed
      Copper Contributor
      Exactly! I have also posted a question in power platform community.

      https://community.powerplatform.com/forums/thread/details/?threadid=cfb09a76-455a-ef11-a317-0022482822d9

Resources