Sun, 07/10/2022 - 13:03 By David Uhlmann Contributor Lloyd Sebag
4 comments
How to get dynamic Record URL in Power Automate

How to get dynamic Record URL in Power Automate

There seems to be some amount of confusion on the web about how to use Power Automate to get the dynamic record URL of a record in Dynamics CE.

Power Automate comes with a few onboard tools. To understand what we are talking about here. A typical Dynamics CE URL, here for an opportunity record, might look like this:

How to get dynamic Record URL in Power Automate

If you want to create this URL inside a Power Automate flow, for example, to put it inside an approval e-mail you need to think about how to do it.

For example, you can parse the JSON output of an action to get the URL of the Dynamics instance:

How to get dynamic Record URL in Power Automate

The body part contains many technical details that are exchanged inside the flow while it is running. Among them is also a URL. This output can later be used with an expression like uriHost(body('GetOpportunity')?['@odata.id']) can be parsed. From this you will get the following URL:

https://org18eb47a1.crm4.dynamics.com/. However, what is still missing is the App ID and the GUID of the record to assemble the link. 

If you search the net on how to assemble this link dynamically you will find a few sources that follow two approaches. The first approach tries to determine all important components (Dynmics URL, App-ID, and GUID) with flow board means, while the second approach relies fully on JavaScript. However, both approaches have a fundamental disadvantage. They (often) assume that the components of the link that are between those "core" elements do not change. Likewise, these solutions are valid but still somewhat of a "tinker". 

So our goal is something like this:

How to get dynamic Record URL in Power Automate

Well, there is a simple trick to get to this link. This one uses good old Dynamics CE onboard tools. What to do here, at least that would be my suggestion, is:

1.) Create a new field (I called it "RecordURL").

2.) Set up a "Real-Time" workflow on the corresponding entity (Important NOT run workflow in the background - It has to be the real-time one!)

3) Whenever changes are made to the record (for example, when saving), the dynamic URL is written into this field.

4) Using this field in Power Automate

How to get dynamic Record URL in Power Automate

We can now use this field in our Approval Flow. Whenever an approval email is being sent, the person will receive a direct link to the record:

How to get dynamic Record URL in Power Automate

This screenshot also shows that these days you can forget about hyperlink formatting, as this is done by the tool for you. So let's check if this one works out:

How to get dynamic Record URL in Power Automate

Because Sales is probably the most obvious case for approval processes, I have created a simple approval process as an example here.

This checks if the amount is above 3 million USD and if the approval status is not "Yes". After the user hits save the flow is triggered and contains the URL to the record:

appr email

When I click on the link I get directly to the record. And this is more or less it. If you have trouble building this do not hesitate to reach out to me. p.s: sometimes it is a good idea to check the "good old" onboard things :-)

How to get dynamic Record URL in Power Automate

Comments

David this is by far the most sane solution that I have found. Thank you for posting!

For anyone wanting to know how to set up a "Real-Time" workflow on the corresponding entity. This community post was useful for me: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/How-to-configur…
1. Navigate to https://make.powerapps.com and select the environment
2. Click on Gear Icon at the Top --> then Select Advance Settings
3. Click on Process in the Process Center
4. Click on New then Make Sure you are not selecting Background Process to run it in a Real Time
5. Select Entity and Provide Name and Select Type as Workflow

Thu, 02/09/2023 - 21:19
Owen Wetherow (not verified)

Be careful with using a workflow to hard code the url in an environment in the event that the data is migrated to a new host or restored to a different environment.

Wed, 03/15/2023 - 16:29
Daryl (not verified)

Yes what Kaare said is, to my knowledge, correct. Just be aware that this article is "just" one way to do it. You can grab the URL also with JS, with a Power Automate Cloud flow, with a plugin etc. I am not claiming by any means that this mechano fits all use cases. I just wanted to help some people who had trouble with this. Nowadays I use PA in 95% of the cases for similar requirements.

Wed, 07/19/2023 - 13:14
David (not verified)

In reply to by Kaare (not verified)

Add new comment

Image CAPTCHA
Enter the characters shown in the image.