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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to get the URL of ...
Microsoft Dynamics CRM (Archived)

How to get the URL of activity record

(0) ShareShare
ReportReport
Posted on by epark06 1,328

I have a table on activitypointer (in powerbi) and I'm trying to generate the URL of the record using the below formula. However the URL is prompting me to create a new activity. Any help would be appreciated.

Activity URL = "myorg.crm.dynamics.com/.../drillopen.aspx{" & activitypointers[activityid] & "}&LogicalName=activitypointer"
0413126.Capture.PNG

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    pavanmanideep Profile Picture
    pavanmanideep 1,331 on at

    Please see below threads...

    www.inogic.com/.../quickly-open-entity-record-from-power-bi-report-in-dynamics-365-crm

    crmtipoftheday.com/.../hyperlink-from-powerbi-to-dynamics365

    Hope this fulfills your requirements...

  • epark06 Profile Picture
    epark06 1,328 on at

    Hi, I've tried both links you posted and it's still directing to a create New Activity page.

  • Verified answer
    epark06 Profile Picture
    epark06 1,328 on at

    Resolved, had to specify the correct entity type code. Used multiple IF statements with check on activity type.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans