import flow error

[GeekAlf_Pro]

Hi !

i built a powerapp with 4 powerautomates.

i have "test" app and flows and i want to import it with my production account.

i'm in the same tenant and the same environment

i always have an error with 3 out of 4 flows

Échec de l’enregistrement du flux avec le code « MultipleErrorsOccurred » et le message « The dynamic operation request to API 'sql' operation 'GetProcedure_V2' failed with status code 'Unauthorized'. This may indicate invalid input parameters. Error response: { "status": 401, "message": "Permission Exception.\r\n inner exception: Internal error: dataSourceCredentials\r\nclientRequestId: aaaaaaa-777dd-4f65-81bb-zzzzz", "error": { "message": "Permission Exception.\r\n inner exception: Internal error: dataSourceCredentials" }, "source": "sql-we.azconn-we-003.p.azurewebsites.net" };The dynamic operation request to API 'sql' operation 'GetProcedure_V2' failed with status code 'Unauthorized'. This may indicate invalid input parameters. Error response: { "status": 401, "message": "Permission Exception.\r\n inner exception: Internal error: dataSourceCredentials\r\nclientRequestId: aaaaaaa-999d-4f65-81bb-384zzzzzzzz", "error": { "message": "Permission Exception.\r\n inner exception: Internal error: dataSourceCredentials" }, "source": "sql-we.azconn-we-003.p.azurewebsites.net" } »

i checked the gateway, the connection,

i set the connexion with an sql account that is db owner

It's weird because i can create from scratch flows with the connection but i still can not import the flows that are linked to the database due to an "Unauthorized" code....

Any help would be welcome !

[SudeepGhatakNZ]

@GeekAlf_Pro ,

If you are in the same tenant and same environment, can you not just create a copy of the app?

[GeekAlf_Pro]

hello @SudeepGhatakNZ and thanks

yes i will use your suggestion if i don't find the solution.

it's because i'm in the same tenant and environment that i want to separate the accounts.

[GeekAlf_Pro · Accepted solution]

Hello,

I finally managed to import my flows.

it was the sql connection the problem.

so i create from scratch a flow to my sql database

i exported the new flow and open the definition json et got the new sql database connection

Then i opened the others definition json and remplace the value of the sql connection with this new value.

and it worked great