Power Automate - Form API Sharepoint HTTP Request fail

Question

Hi

I using SharePoint HTTP request to call Microsoft Form API to Open and Close Form Since Jan.2024 but since 20 Sep. 2024 the flow show error and other similar flow now not work. Error as follow.

{ "statusCode": 400,"headers": {"Cache-Control": "no-store, no-cache","Pragma": "no-cache","Set-Cookie": "","Strict-Transport-Security": "","x-ms-request-id": "","X-Content-Type-Options": "","X-Frame-Options": "DENY","x-ms-tenant-id": "xxxxxxxxxxxxxxxxxxxx","Timing-Allow-Origin": "*","x-ms-apihub-cached-response": "false","x-ms-apihub-obo": "false","Date": "Fri, 20 Sep 2024 10:05:10 GMT","Content-Length": "277","Content-Type": "application/json","Expires": "-1"},"body": {"status": 400,"message": "Unexpected response from the service\r\nclientRequestId: ","error": {"message": "Unexpected response from the service"},"source": ""}}

Answer 1

Dear All,

Thanks for your updates.

It seems that the related team are working on the tickets and further investigating on the issue with some of you as you are still experiencing the similar issues when using the Send HTTP to SharePoint connector in Power Automate to get the Forms data with API.

I understand the urgency of the issue and it may affect the automation of your work process in your environments. I'd like try my best to help you before you get the final result from the related team.

Currently I'd like to provide another workaround here for you to give a try and see if it works in your environments.

As another way for the Forms data with API in Power Automate, you may try the HTTP connector (Premium) in Power Automate to see whether you can call the Forms API to see the result in your environment.

You may need to first register the app which can call the Forms API in Microsoft Entra (Azure AD). Add the Microsoft Forms permissions to the app and grant the admin consent by clicking on API permissions like the following.

Now select Certificates and secrets to create the secrets value and copy and paste it to Notepad. Otherwise it will be invisible later.

After pasting all parameters such as Tenant ID, User ID, App ID (Client ID) and Secrets Value, now go to the HTTP connector and fill in all required parameters.

I call https://forms.office.com/formapi/api/**tenantid**/users/**userid**/forms('**formid**')/responses as a test in HTTP.

Result:

Using the HTTP action to make requests with Microsoft Flow - Microsoft Power Platform Blog

Quickstart: Register an app in the Microsoft identity platform - Microsoft identity platform | Microsoft Learn

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Answer 2

Is there a way to do this without getting the secret?

Answer 3

Dear Apsvcacct,

To use Active Directory OAuth with the registered app in the HTTP connector, you need to get the Secret value.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Answer 4

How do I register the app, I am very new at this.

Answer 5

Dear Apsvcacct,

You can follow the steps in the article below.

Quickstart: Register an app in the Microsoft identity platform - Microsoft identity platform | Microsoft Learn

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator