Skip to main content

Post Entity in CRM


Problem Statement: I had to make an SSRS report that will display the latest post against a Lead.
Post as an Entity is not visible in customization, also in advance find of Lead, we do not have any related attributes from post. This made it difficult to generate the query.

Eva Corets Lead Lead v Lead to Oppa-tunity Sale... Active for 29 days Summary Details Files Contact Topic Likes our products Type Item based First Name Last Name Job Title Purchasing Assistant Business Phone 555-0138 Related Qualify (29 D) Timeline Enter a note... Develop 11, pa rtner How did you hear about us? Propose g Activity Appointment Email Phone Call ask Alert Subscription Booking Alert Invite Redemption Portal Comment Project Service Approval Note OneNote Post Hot Rating Neu Sta tu Phone Call from Veronica Quek (Sample Data) Tried to reach out to Eva. Went to VM. Tried to reach out to Eva. Went to VM. Auto-post on wall Eva Corets SYSTEM created Eva Corets CIC data available

Solution:

If we check the advanced Find for posts, we will not find any field that is providing related details of lead. But if we go to edit columns and check the available columns, we will get regarding column.
Query Ss'.•ed ЯМО Resu[ts save save As Edit Co]umns Edit Prcper1ies cIear Groug С: Groug 0R oetsils for: DowrIoad Fe1cF ОеЬ [ГАМ] Created Ву Created Ву (Delesate) Created Оп Mcdifed Оп Source Crested Ву (DeIesste) (User) Crested Ву (User) Mcdifed Ву (DeIegste) vser) Mcdifee зу (User)

Look for: Post Edit co Edit colum Created On O Note: Add Columns Select the columns to add to this view. Record Type CJ Display Name Created By (Delegate' Regarding createdonbeha Ifby regardingobrctid Type Lookup Lookup Single One of Text Cancel Rilsina PegadO ontrols Sorting rties Cancel

We can use the below XML  Query to generate our SSRS report.
<fetch version:" 1.0" output-format="xm -platform" > <entity name: "post" > <all-attributes/> <filter > <condition operator OOOD3A34AOAA'
In the query, the value is the GUID of Lead.

Comments

Post a Comment

Popular posts from this blog

Get Business Process Flow Stage Id using API Query

Developers may need to get the stage ids of BPF stages in order to use in power automate or JS. Here is a blog that will help. API Query-   https:// CRMURL.dynamics.com/ api/data/v9.0/processstages?$select=stagename&$filter=processid/workflowid eq BPFGuid   Eg: 1) Get the GUID of  Business Process Flow whose stage details you need. Replace below Query with Your CRM URL and BPF GUID. https://Test130.crm.dynamics.com/ api/data/v9.0/processstages?$select=stagename&$filter=processid/workflowid eq 9128E4D1-1234-4852-ABD0-A63A6ECA5C5D   Output:    The output will provide the stage name and ID.
Post a Comment
Read more

Power Automate to Access SharePoint Recycle Bin

Introduction : A ccess Recycle Bin of SharePoint using Power Automate. Steps: Actions: select "Send an HTTP request to SharePoint" Enter the below details: Site Address: Select your site address from the list. Method: GET Uri, Headers: Refer the screenshot below. Pls. Note: Trigger used was When a File is Deleted- SharePoint Connector. Select Action "Parse JSON" In parse JSON, the content is the body of HTTP Response Enter the below Schema: { "type" : "object" , "properties" : { "odata.metadata" : { "type" : "string" }, "value" : { "type" : "array" , "items" : { "type" : "object" , "properties" : { "odata.type" : { "type" : "string" }, "odata.id" : { "type" : "string" }, "odata.editLink" : { "t
Post a Comment
Read more

Dynamic, Multiple Recipients of D365 Email in Power Automate

When t he activity parties (TO, From, CC) ae static, we can easily send emails. However here is how we can set the activity party dynamically on the Email.    In above screenshot we can see the Activity party attribute is populated for single value and is static to only a single entity record GUID.   Solution: The create a record of Email message is as below, here we are entering the attributes of activity party, by clicking on "Switch to Input entire array" You will get the Array format, the participationtypemask is TO, FROM,CC while the partyid@data.bind is the email address. Now all you need to do is create a dynamic array, You can use append to array variable action to create an array with participationtypemask as per your requirement. Example: get all users whom you need to send email, append the user id to array. pass this array as input to the Activity Parties field in create an email record.  
Post a Comment
Read more