Answered

Connecting to on-premises gateway - "The 'x-ms-apim-token' header is not valid: the XRM URL is omitted."

(0) Share

Report

Posted on by aqyx

Installed a gateway successfully on a client device which will be running UI flows, all working fine locally and network test reports successful. When using the 'Run a flow built by Power Automate Desktop (preview)' action in Power Automate, the gateway is available from the drop-down, but the test connection fails. The error is:

Test connection failed. Details: The 'x-ms-apim-token' header is not valid: the XRM URL is omitted.

EDIT: When trying to create a UI flow from the Power Automate admin center, I see a RpaMissingXrmInstanceApiUrl error, so it looks to be a CDS issue. This environment does have a valid CDS database, so I'm not sure where the issue lies.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

matow_MSFT on at

Like (0)

Report
@aqyx Sorry you're seeing this! To help with troubleshooting, can you please share the results of the below? Additionally, in some cases, there is a delay of 5+ minutes after the database is created before it is visible in Power Automate.

What is the version of the database for the environment as shown in the Power Platform Admin Center (https://admin.powerplatform.com/environments)? The "Database version" field should be visible in the Version tile for the environment.
Visit https://flow.microsoft.com, press Ctrl+Alt+A, and search within the page for "xrmInstanceUrl". Are the values for these three fields filled in (no need to share) or empty?

Was this reply helpful? Yes No
kitUser 27 on at

Like (0)

Report

I am experiencing a similar issue. Were you able to resolve this?

Version: 9.1.0000.23474
Values are empty

Was this reply helpful? Yes No
Verified answer

matow_MSFT on at

Like (2)

Report

@kitUser Within the Power Platform Admin Center view of the environment, is there an option to create a database or is one already present? If there's already a database, please try going to Security roles (at top right of the environment page) -> Environment Maker, and add your user account if it is not listed.

More info on the Environment Maker role

Was this reply helpful? Yes No
kitUser 27 on at

Like (0)

Report

@matow Adding my user account to the Environment Maker role resolved this issue. Thank you very much for your help

Was this reply helpful? Yes No
kitUser 27 on at

Like (0)

Report
I wanted to provide additional information I found when receiving this error. I hope this helps.

Steps to produce RpaMissingXrmInstanceApiUrl error
Create new Sandbox Environment
Click Add New Database to new Sandbox Environment
Leave defaults
Click Add
Check Ui Flows in Power Automate

Steps to work around RpaMissingXrmInstanceApiUrl error
Create new Sandbox Environment
Click to Add New Database to new Sandbox Environment
Click + Select Security Group
Click Cancel
Click Add
Check Ui Flows in Power Automate

I am unsure why pretending to add a security group to the database fixes this error. Anyone know what I am missing here?

Was this reply helpful? Yes No