Unanswered

Error response: { "error": { "code": "707", "message": "UnauthorizedAccess to CDB. Inner Message: {\"error\":{\"code\":\"OperationForbidden\",\"message\":\"Unauthorized Access\",\"innerError\":{\"code\":\"UnauthorizedAccess\"}}}", "@ms.form.error.type": "ExpectedFailure" } }'.

(1) Share

Report

Posted on by daria_energy

Hi,

I am trying to build a flow where members of our organisation can self-update their details should they change. What I want is the following:

They fill out a microsoft form with their details,
The flow finds the record in our member list (sharepoint list) with the same email address as the form response
The flow over-writes the previous data in that record with the form responses

I have not even been able to get past here:

I am the owner of the form and of the flow. I am the only owner of either the form or the flow.

Yet, the form does not appear in the drop-down list. The form I am trying to link is called "CDA Member Information Update Form"

I then try to link the form by manually providing the form ID. The first step appears to accept the form ID, but the second step then returns the following:

What the hell!?!? This shouldn't be this hard! I am not even up to the hard part of this flow!

When I try to save the flow I get this error message up the top :

I am the one and only owner of every object involved in this flow and of the flow it's self - what on earth could I not be authorized to access? Why is this action "forbidden"?

Please help

Cheers

All responses (3)

Answers (0)

daria_energy 4 on at

Like (1)

Report

Re: Error response: { "error": { "code": "707", "message": "UnauthorizedAccess to CDB. Inner Message: {\"error\":{\"code\":\"OperationForbidden\",\"message\":\"Unauthorized Access\",\"innerError\"

Hi Sunshine,

The issue is not primarily that the flow won't save, that is just a byproduct of the core problem. The core problem is that the form will not link to the flow, and therefore cannot recover the dynamic content- even though I own both of them.

The error that it is giving me would suggest that it's a permissions problem (unauthorized access to CDB) - but that can't be it because I am the owner of the form and of the flow.

As for "unnecessary loops", power automate forces you to put a loop around the action because the action "get response details" technically retrieves a list of responses to the form, and the flow must then iterate over every response. The loop appears automatically when you set the field "response ID" to "list of responses"; the action "get response details" almost always requires a loop to work.

I have read the thread that you linked, unfortunately it is describing different problems to the ones that I am encountering. Switching to the old designer does not solve the problem, the same error message appears.

Kind Regards
Lil
v-yetonggu-msft on at

Like (1)

Report

Re: Error response: { "error": { "code": "707", "message": "UnauthorizedAccess to CDB. Inner Message: {\"error\":{\"code\":\"OperationForbidden\",\"message\":\"Unauthorized Access\",\"innerError\"

Hi @daria_energy ,

I think this link could help you:

Solved: Error saving flow - Power Platform Community (microsoft.com)

Best Regards,

Sunshine Gu
v-yetonggu-msft on at

Like (1)

Report

Re: Error response: { "error": { "code": "707", "message": "UnauthorizedAccess to CDB. Inner Message: {\"error\":{\"code\":\"OperationForbidden\",\"message\":\"Unauthorized Access\",\"innerError\"

Hi @daria_energy ,

1)Please try to switch classic designer, and re-created flow:

2)Make sure your form ID is correct.

3)Avoid unnecessary loops nested outside the ‘get response details’ control.

I did a test for your reference.

In my scenario:

Best Regards,

Sunshine Gu