Send e-mails with a link to the record via Power Automate

Today we gonna have a look at how to send an e-mail with a link to a CDS record via Power Automate.

In the good old classic workflows, you could directly reference the "record URL" from the dynamic data. But since UCI has been launched and you have the possiblity to target different apps, you already had to do a few more steps in the classic workflows as well.

The URL to a CDS record consists of multiple things:

• CRM URL
• appid
• entity name
• record id

So we will work this out one after the other.

First we add a "List record" action to lookup the appid of the app, we target. We look for "model driven apps" and filter by the name of the app:

Then we initialize a variable with the resulting app id:

Then we initialize another variable and extract the CRM_URL:

Then we fetch our records, where we want to send out a notification with a link, in this case we look for workorders fullfilling certain criteria:

Now we compose the record URL:

As a next step we create a new e-mail and insert the record URL as a hyperlink in the description field:

Last we have to invoke a web api action to send the e-mail: