Embed PowerBI Report to CRM Form with filters using Power BI Embedder

Introduction:

You can now add your Power BI report to Dynamics CRM form and also add filters to the report easily with Power BI embedder tool of XRM Toolbox.

Explanation:

Download Power BI Embedder in XRM Toolbox and connect to your organization

Chose the D365 CRM Entity, Form, Tab, Section where you want to embed the Report.

In formatting change the rowspan to ensure the report fits on the page as needed.

In Power BI Config add the Group ID, Report ID and Page

you will find this on the report URL in Power BI

https://app.powerbi.com/groups/98765ty7-nju7-567y-vft5-12345678yytr/reports/4fb4555-9d54-yyff-9987-f49999999999/ReportSection5afdbb2222228c4221

Group ID- Yellow

Report ID- Red

Page - Green

click on the filter checkbox to add filter

PBI table - Name of table in Power BI that contains the field to be filtered

PBI Column - name of field to be filtered as per Power BI

CDS Field- select the CDS field from dropdown, this will be the equal to value of filter.

Note that PBI Table and Column are case sensitive.

Click on Publish Report and you can refresh dynamics form to view the embedded report.

Comments

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.

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

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.

Forecloud Technologies

Search This Blog