Integrate the approval center into a model driven app/Dynamics 365 CE


One more insightful blog post by @Mehdi.

Mehdi El Amri's avatarXRM Tricks (Power Platform & Dynamics CRM )

Power Automate provides a standard solution to manage approvals in a Dataverse environment. Approval requests can be easily generated from cloud flows. Users have the ability to view and respond to approval requests from email, teams or the approval center which is accessible from the power automate website only.

Today, I will present a way to respond to approvals from a model driven app directly. Also, the approval requester will be able to cancel his request from the MDA in one click.


The approver can approve, reject, or assign the approval to a new approver in the organization:

The approval requestor can cancel his or her own approval request:


To implement this, we just need to use the widgets provided by the MsFlow js SDK. Yes, there is an SDK that allows us to generate some cool widgets. The approval center is one of them. Please refer to the documentation.

View original post 409 more words

Secrets of the Dataverse: The Report Wizard


Nick Doelman's avatarThe ReadyXRM Blog by Nick Doelman

Anyone who has been working with Dynamics CRM/Dynamics 365 at some point likely tried the Report Wizard. The Report Wizard was introduced in Dynamics CRM v4.0 as a way to quickly create ad-hoc reports.

A video version of this blog post can be found on the 365.Training YouTube channel.

Reports created using the Report Wizard are not necessary pretty, but can be quite functional and are a good way to extract data from Dataverse quickly. You do not need any of the Dynamics 365 apps deployed, the report wizard will work just fine on a “vanilla” Dataverse instance.

If you are an old-school Dynamics CRM person who knows how to build a report using the wizard, you can skip to the bottom of this post where I show how to launch Report wizard reports directly from a canvas Power App.

Creating a Report using the Report Wizard

You…

View original post 596 more words

How to setup – Azure Synapse Link – Microsoft Dataverse


Azure Synapse Link (earlier known as Export to Data Lake Service) provides seamless integration of DataVerse with Azure Synapse Analytics, thus making it easy for users to do ad-hoc analysis using the familiar T-SQL with Synapse Studio, build Power BI Reports using Azure Synapse Analytics Connector or use Azure Spark in Azure Synapse for analytics.

As a first step, we need to create the Azure Synapse Workspace.

Login to Azure Portal (https://portal.azure.com/ ) with appropriate roles and create a Synapse workspace.

https://docs.microsoft.com/en-us/azure/synapse-analytics/get-started-create-workspace

Wait for the deployment to be complete. Below are the resources created as part of the deployment.

Login to the maker portal (https://make.powerapps.com/ ) and select the appropriate environment

Click on Azure Synapse Link and check the Connect to your Azure Synapse Analytics workspace (preview) and specify the storage account created in the previous step

Here we have selected the Contact and System User table for export.

On clicking Save, we got this error couple of times, even though the account being used was Owner across the Azure resources. Trying save 3-4 times more, allowed the link to be created.

Click on Go to Azure Synapse Analytics workspace, opens the Azure Synapse Studio

Within Synapse Studio we can see our Dataverse Database and run query.

Similarly, we create a Power BI report with Azure Synapse Analytics (SQL DW) connector.

Copy the Serverless SQL endpoint of the Synapse workspace.

Select the Direct Query option.

https://azure.microsoft.com/en-gb/blog/power-your-business-applications-data-with-analytical-and-predictive-insights/

Hope it helps..

Advertisements

How to – improve data migration performance – SSIS & Azure Data Factory (Dataverse / Dynamics 365)


In one of our projects, we were executing SSIS Packages (KingswaySoft’s Dynamics 365 SSIS Integration Toolkit) under Azure-SSIS Integration Runtime in Azure Data Factory.

Check out –

Deploy and run SSIS Package in Azure Data Factory

Deploy and run SSIS Packages that use KingswaySoft’s SSIS Integration Toolkit on Azure Data Factory.

After trying out different combinations, we eventually settled with batch size as 10 and thread as 15.

https://nishantrana.me/2021/06/08/data-migration-optimum-batch-size-and-threads-for-maximum-throughput-microsoft-dataverse-dynamics-365/

Also, we used multiplexing – running the CRM Destination Component under different application users.

To be precise, 4 in our case and we can increase it get further  improvement in the throughput.

And also based on the recommendation of our Microsoft’s Fast Track Architect we raised a Microsoft ticket to increase the number of web servers allocated from 2 to 3.

Below were our findings,

the earlier run was using batch size as 100 and thread as 20 with the number of servers as 2.

On updating the batch size to 10 and thread as 15 and with the number of servers allocated increased to 3, there was a huge performance gain.

Check the table below – 

The above table is sample run in the sandbox environment, during the final run in production we got the number of servers allocated, increased to 6, gaining further improvement.

Also, check out the below blog post to understand about the affinity cookie and its affect on performance, in case if we doing migration using custom code –

https://markcarrington.dev/2021/05/26/improving-bulk-dataverse-performance-with-enableaffinitycookie/

Hope it helps..

Advertisements

Microsoft Teams Integration with D365 on custom entity


Ajit Patra's avatarAjit Patra

To enable Microsoft Teams in D365, Go to Settings –> Administration –> SystemSettings –> General Tab and flip the below highlighted options to Yes.

Once done, we’ll be able to see Collaborate button on the ribbon as shown below.

By default it’ll be enabled on several OOB entities as mentioned here: https://docs.microsoft.com/en-us/dynamics365/teams-integration/teams-collaboration#record-types-that-support-microsoft-teams-integration

However, we can also enable it on custom entity programmatically. Below is the screenshot of a custom entity “new_cidproduct” before enabling Teams integration on this entity.

We can use msdyn_SetTeamsDocumentStatusWeb API action to enable/disable Teams integration on a specific entity or a set of entities. Here, I have used my favorite Postman for the demo. Below are the request details:

Method: POST
URL: https://org.crm.dynamics.com/api/data/v9.0/msdyn_SetTeamsDocumentStatus
Body:
{
“Enable”:true,
“LogicalEntityNames”:”[“new_cidproduct”]”
}
Authorization: Configure the token to be passed along with the request.

Below is the screenshot of the request using Postman.

Once done with building…

View original post 62 more words

Troubleshooting OmniChannel Engagement Hub: Setup Issues


Tricia Sinclair's avatarEverything D365

I’m a huge fan of the Omni Channel Engagement Hub. You may have gathered this fact if you’ve read previous blogs, seen previous posts or watched me demo the product. I see the Omni Channel Engagement Hub as a game changer – it’s much easier to get up to speed with than it’s counterpart USD (Unified Service Desk) and it has so much more to offer than standard D365 Customer Service. Omni Channel was demoed at the recent Microsoft Business Applications Summit (if you missed it you can catch up on it here) and I hope this will have whet the appetite for more people to start looking into how they can adopt this product.

With that being said, Omnichannel is not perfect, there are some issues which I have faced and numerous people have also faced during their setup and configuration of OmniChannel. To hopefully make the future…

View original post 666 more words

Nishant Rana's Weblog

Everything related to Microsoft .NET Technology

Skip to content ↓