Hi All,

Greetings for the day !!! Today new issue and solution !!

Details / Background :

• We have Power App form in which – submit button triggers the Power Automate
• We have implemented Power App form and Power Automate on our local tenant
• To have these in customer tenant, we exported Power Appp from our local tenant and imported to customer tenant, which happened successfully. Of course we need to change the connections used in Power App but at least no issues
• When we exported the Power Automate and try to import in customer tenant we are getting an errors

Errors / Issue :

Import conflicts
You’ll need to resolve these conflicts before importing the package

Resource
Knowledge Junction PowerAutomate Import-Export demo

Import setup
Create as new

Error
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: { “error_description”: “Exception of type ‘Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException’ was thrown.” };The dynamic operation request to API ‘sharepointonline’ operation ‘GetTable’ failed with status code ‘Unauthorized’. This may indicate invalid input parameters. Error response: { “error_description”: “Exception of type ‘Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException’ was thrown.” };The dynamic operation request to API ‘sharepointonline’ operation ‘GetTable’ failed with status code ‘Unauthorized’. This may indicate invalid input parameters. Error response: { “error_description”: “Exception of type ‘Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException’ was thrown.” }’.

Cause of issue:

• When we implementing this Power Automate in our local tenant, we have used our local tenant SITEs URLs and LISTs
• Our assumptions is with this is – Power Automate will be imported successfully and then we can update the SITEs URLs in POWER AUTOMATE in destination tenant
• What exactly happens is –
  • Before import we change the connection but Power Automate still contains source tenants references
  • It tries to authenticate source references with destination connection and it fails and “Unauthorized” error comes and as in above figure
  • Hence the import fails

Workaround / Solutions :

• Best practice is to use of “Environment Variables“, but I’ll come up with separate article on Environment Variables
• Since we have time constraint, also we have big workflow, it was not possible to rewrite whole Power Automate in destination tenant or change it now with environment variable and export and import again
• There is another workaround – to change the source references like SITE URLs and LISTs GUIDs in Power Automate package which we exported and imported
• When we export Power Automate it creates the package – zip file for example as – KnowledgeJunctionPowerAutomateImport-Exportdemo_20220405022915
• If we extract exported package it contains the respective files / folder structure as

• As in above fig – one file is definition.JSON file which contains all the references to source tenants as

• Please have a look at above fig, in definition.JSON file there are references to source tenant URLs and List IDs
• As in above fig “table” represents the our LIST and those respective list IDs
• So we need to change the references to source SITE URLs and respective LIST IDs
• Once we updated to those we need to again create package – just we need to zip those and we are ready to go
• This approach worked for us , this is quickest way to solve this issue
• But I still recommend the use of Environment Variables

Thanks for reading !!! In case any issue / suggestions / thoughts feel free to connect us !!!

HAVE A GREAT TIME AHEAD 🙂 LIFE IS BEAUTIFUL 🙂