Answered

The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'Unauthorized'. This may indicate invalid input parameters

(0) Share

Report

Posted on by johnjohn123

3,506

I have exported a solution which 5 power automate flows from one tenant as un-managed solution. then i import it inside another tenant, but i got this error/warning:-

Solution "Certification" imported successfully with warnings: Flow client error returned with status code "BadRequest" and details "{"error":{"code":"InvalidOpenApiFlow","message":"Flow save failed with code 'MultipleErrorsOccurred' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'Unauthorized'. This may indicate invalid input parameters. Error response: {\r\n \"error_description\": \"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown.\"\r\n};The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'Unauthorized'. This may indicate invalid input parameters. Error response: {\r\n \"error_description\": \"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown.\"\r\n}'."}}".

now i checked the exported flows and they are valid.. but not sure why i got this warning?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @johnjohn123,

The GetTable typically refers to a dropdown within a SharePoint action. This could refer to a list/library it cannot find, but it also can refer to a view which doesn't exist in the target environment. In other words, this error can have different root causes and it is hard to tell right now, what is causing this.

Can you share a bit more details what you type of SharePoint connector actions you are using in that solution? Are you for example using environment variables (of type source) for the site and list/library selections in the configuration of those actions?

Below are two examples of the same type of issue, which might help troubleshooting?

https://sharepains.com/2021/09/16/turn-on-solution-based-flow-power-automate/

https://powerusers.microsoft.com/t5/General-Power-Automate/SharePoint-GetTable-failed-with-status-code-NotFound-List-View/td-p/1828698

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@Expiscornovus yes the environment variables refer to a SharePoint site and SharePoint lists and libraries...

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @johnjohn123,

Thanks for confirming you are using environment variables of the date source type. I assume you have updated the current values of those environment variables to point to the new sites and lists in the new tenant?

What type of SharePoint actions are you using in those 5 flows. Get Items, Send an HTTP request to SharePoint, etc.?

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@Expiscornovus Yes i am using all these actions ; Get Items, Send an HTTP request to SharePoint, etc.?

and when i imported the solution on the destination tenant, i were not asked to provide values for the environment variables

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @johnjohn123,

I believe that happens when you not remove the values before exporting. I think the docs highlight this over here:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/environmentvariables#enter-new-values-while-importing-solutions

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report

@Expiscornovus yes i did not remove them before the export.. Also if I remove the environment variables values will this break the source solution ?

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @johnjohn123,

Follow the steps below (with the remove from this solution option for the current value field). In that case the value should remain in the dev environment, but removed from your exported solution:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/environmentvariables#how-do-i-remove-a-value-from-an-environment-variable

Was this reply helpful? Yes No