Dynamics Community Forum Thread Details

How To Pin An Email To The Case Timeline Using Power Automate?

Hello,

I have a Power Automate that retrieves an email for a Case. Now I want to pin that email to the timeline of the Case. It does not appear as easy as setting 'Ispinned' to yes on the email.

Can it be done and has anyone done this? Can you please share how you did this?

Any help is appreciated,

Thank you,

Jim

Categories:

Microsoft Dynamics CRM

Other

So, I've figured out the first half, to pin an email I need to insert a record into msdyn_timelinepin. I have that working in xrmtoolbox sql4cds, now how do I do it in Power Automate?

insert into msdyn_timelinepin (msdyn_formrecordid, msdyn_pinnedrecordid, msdyn_pinnedrecordlogicalname, msdyn_timelinecontrolid, partitionid, ttlinseconds)
values('The GUID of the Case Record', 'The GUID of the Email Record', 'activitypointer', 'GUID of the Timeline Control', 'Concat of GUID of Case Record+GUID of Timeline Control', 31536000)

the case and email GUIDs, you get those from the URL when in the records main form
activitypointer is a constant for any activity record, since emails are closed activities, this makes sense
timelinecontrolid not sure if this is specific per environment or not, but just pin an email, query the table and whatever GUID is there is the one you use.
partitionid is the concat of the two GUIDs with a '+' between them, no space. Why this needs to exist, does not make sense, but populate it anyways. If you don't you will get an error when trying to query the table after the insert. You will need to delete the record before a select will work on the table.
31536000 is the number of seconds in 365 days. I'm guessing the system will automatically unpin the record after 1 year. I don't know if any other value will work and I'm not willing to take a chance, this is the value MS used so that's good enough for me.

Now to get a record inserted into msdyn_timelinepin using Power Automate, but how?

Thank you,

Jim

Quick Links

Leaderboard