Unanswered

Power Automate to clear Forms Responses

(0) Share

Report

Posted on by Tomas1986

I am trying to create a Power Automate flow that will automatically clear all form responses at 0130 am every day. But I am having a few issues and dont know where I have gone wrong.

I did some searching online and found This Video which shows away to clear the responses. But when I have put this into my flow it errors with

"Unexpected response from the service clientRequestId: 73f7ddd5-a08f-4426-a7c5-8472948fd771"

I have included snips my flow below below.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Tomas1986 ,

I think there could be two areas to look at.

First, check the URI. If you change the Method to GET, do you get any responses back? If yes, then the URI is fine.

Second, Check if the account of the flow connection is authorised to delete the responses.

Was this reply helpful? Yes No
Tomas1986 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Outputs for Get Command

"
{
  "status": 400,
  "message": "Unexpected response from the service\r\nclientRequestId: 755232c6-45b5-4dc0-a55f-88cc66c15ddd",
  "error": {
    "message": "Unexpected response from the service"
  },
  "source": "sharepointonline-ase.azconn-ase-001.p.azurewebsites.net"
}"
Headers
"{
  "Pragma": "no-cache",
  "Cache-Control": "no-store, no-cache",
  "Set-Cookie": "ARRAffinity=5b946cda2cdeaacc2187b073c9b48d83f2e55862456e7f63f058f309a3b34fa2;Path=/;HttpOnly;Secure;Domain=sharepointonline-ase.azconn-ase-001.p.azurewebsites.net,ARRAffinitySameSite=5b946cda2cdeaacc2187b073c9b48d83f2e55862456e7f63f058f309a3b34fa2;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-ase.azconn-ase-001.p.azurewebsites.net",
  "x-ms-request-id": "755232c6-45b5-4dc0-a55f-88cc66c15ddd",
  "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
  "X-Content-Type-Options": "nosniff",
  "X-Frame-Options": "DENY",
  "Timing-Allow-Origin": "*",
  "x-ms-apihub-cached-response": "true",
  "x-ms-apihub-obo": "false",
  "Date": "Wed, 17 May 2023 02:19:21 GMT",
  "Content-Length": "279",
  "Content-Type": "application/json",
  "Expires": "-1"
}"

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
What that means is that the Endpoint isn't correct.

After going through the API details, I think you are missing /light/

https://forms.office.com/formapi/api/[tenantId]/users/[userId]/light/forms('[formId]')/responses

Was this reply helpful? Yes No
Tomas1986 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Sadly I tried this and still got the same issue. If i changed it from forms.office.com to forms.microsoft.com all sorts of other issues where shown.

I think this might be a lost cause.

Was this reply helpful? Yes No