web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dataverse List rows fa...
Power Automate
Suggested Answer

Dataverse List rows fails instantly with 'HostNotFound' / connection shows Connected

(0) ShareShare
ReportReport
Posted on by

Summary

 

After our production environment was rebuilt via an environment copy (copied to a new Sandbox, then converted to Production), one cloud flow fails on every single run with UnresolvableHostName. The Dataverse connection it uses shows as Connected and works elsewhere. The flow has never succeeded since the copy.

 

Environment background

Original PROD had an issue; Microsoft's guidance was to copy it to a new environment

New environment was provisioned as Sandbox, then converted to Production

Environment is not in Administration mode; State = Ready

Copy completed approximately 8 days ago

Flow was created/copied in on the same day as the copy

The error

json

{

"error": {

"code": "UnresolvableHostName",

"message": "Http request failed with status code 'HostNotFound' and status message: 'No such host is known.'."

}

}

 

Failing action: Microsoft Dataverse → List rows (ListRecords)

 

Key detail: it fails in 0 seconds

 

Looking at the retry history, each of the 12 retries shows:

 

Duration: 0 seconds

Start time and end time are identical

 

This is not a timeout. The hostname is being rejected at resolution time, before any request goes out. Total run duration of ~3h 30m is purely the retry policy backing off between 12 instant failures.

 

Action inputs (raw)

json

{

"host": {

"connectionReferenceName": "shared_commondataserviceforapps",

"operationId": "ListRecords"

},

"parameters": {

"entityName": "xxx_campaignteams",

"fetchXml": "<fetch version=\"1.0\" mapping=\"logical\" distinct=\"true\">...</fetch>",

"accept": "application/json;odata.metadata=minimal"

}

}

 

Note there is no organization URL in the inputs — the host is resolved at runtime from the connection reference.

 

What works vs what fails

FlowDataverse connectionResult

Child Flow (different flow, same environment)Same connectionSucceeded

Failing flowSame connectionFails every run, 100%

 

Both flows are in the same solution, in the same environment, using the same Dataverse connection.

 

What we have already checked and ruled out

Environment is not in Administration mode; State = Ready

No active Microsoft service health incident

Dataverse connection status = Connected (green)

Connection reference in the solution is bound and shows a green check

The same connection succeeds in a different flow in the same environment

Flow status = On

Flow owner (service account) is Active with security roles assigned

FetchXML is valid — the query has not changed and worked pre-copy

Repointed the connection reference to a known-good connection — no change

Recreated the Dataverse connection — no change

Additional observation

 

The Dataverse connection is owned by a service principal. That service principal does not appear in the Application Users list of the new environment (application users are not carried across an environment copy).

 

Our working theory is that the Dataverse connector resolves the target org URL at runtime based on which environments the calling identity has access to. If that identity has no application user in the environment, the lookup returns nothing, the connector builds a request against an empty hostname, and DNS rejects it instantly — which would explain a 0-second HostNotFound rather than a 401/403.

 

We have not been able to confirm this. A comparison environment appears to have the same application user list and does not exhibit the problem.

 

Questions for the community

Has anyone seen UnresolvableHostName / HostNotFound on the Dataverse connector specifically after an environment copy, where the connection itself is healthy?

Does the Dataverse connector resolve the org URL from the calling identity's environment access at runtime? If so, would a missing Application User for a connection-owning service principal produce a DNS-level failure rather than an authorization failure?

Is there any way to inspect the actual hostname a Dataverse connection resolves to? Nothing in the maker portal or admin center appears to expose it.

Are there known cases of a flow retaining stale environment bindings after a copy that cannot be cleared by repointing connection references — requiring the flow to be recreated or the solution re-imported?

Constraint

 

We cannot edit flows directly in this environment (managed solution / no edit rights in production), so Save As and retry-policy changes are not available to us in place. Any suggestion that can be applied via connection references, application users, or the admin center is preferred.

 

Thanks in advance — happy to provide any additional run details, correlation IDs, or screenshots.

new1.png
I have the same question (0)
  • Suggested answer
    Raghav Mishra Profile Picture
    277 Super User 2026 Season 2 on at

    Hi @CU14020458-1, excellent write-up - the detail here makes it much easier to reason about. I will flag up front that I cannot find this error documented for the Dataverse connector on Microsoft Learn, so I will stick to what is documented and be clear about where the gap is.

    Your application user observation is the strongest lead

    Application users are managed per environment. They have to exist, be active, and carry security roles in the target environment before a service principal can operate there. Recreating the service principal as an application user in the new environment is documented in the Power Platform admin center and is the first thing I would correct - regardless of whether it turns out to produce this exact error. Learn covers viewing application users in an environment, creating one, and managing its roles.

    Post-copy items Learn asks you to verify

    • A newly created copy environment is placed in administration mode and background operations are disabled, including workflows. You have said the environment is Ready and not in admin mode, but it is worth re-confirming on the converted environment rather than the original target.
    • Learn asks you to review application components with external connections after a copy and decide explicitly whether to disable them, redirect them, or leave them as is.

    On your third question - inspecting the hostname

    The authoritative org URL and Web API endpoint for the environment are on the Developer resources page in the maker portal. That does not show you what the connector resolved at runtime, but it does give you a known-good hostname to compare against.

    Connection references

    Since the same connection succeeds in a sibling flow in the same solution, I would re-check the binding on the failing flow's connection reference specifically and re-authenticate it at the solution layer rather than at the connection layer. Connection references are solution components in their own right and can be bound independently per flow.

    My honest read

    A 0-second, DNS-level failure on a healthy connection that reproduces on one flow only is not behaviour Microsoft has published guidance for, and I would rather not guess at the mechanism. I would raise a support request from the Power Platform admin center with the run IDs, the retry timings that show identical start and end times, and the environment IDs for both the working and the failing flow. That evidence is unusually clean and should get you to the right engineering team quickly.

    References

    Found this helpful? Please mark ✅ "Does this answer your question?" so others searching for the same issue can find it quickly. A 👍 on "Was this reply helpful?" or a ♥ Like is also much appreciated!

    Raghav Mishra - LinkedIn| PowerAI Labs

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 306 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 169 Super User 2026 Season 2

#3
Haque Profile Picture

Haque 131 Super User 2026 Season 2

Last 30 days Overall leaderboard