Nishant Rana's Weblog

Do you use FetchXML Builder? Please consider helping a friend out.

Dynamics 365 community rallies around Microsoft MVP and FetchXML Builder creator Jonas Rapp

https://msdynamicsworld.com/story/dynamics-365-community-rallies-around-microsoft-mvp-and-fetchxml-builder-creator-jonas-rapp

https://fetchxmlbuilder.com/donate

The ReadyXRM Blog by Nick Doelman

I use the FetchXML Builder on my Power Platform almost on a daily basis. It saves me so much in building SSRS reports, it allows me to build powerful Power Apps portals web templates and it also helps me building Power Automate flow queries.

What is FetchXML Builder? It is a tool that is part of the XrmToolBox that allows you to quickly point and click choose tables from Dataverse (aka entities from Common Data Service/Dynamics CRM), choose the columns, filtering, sorting, etc and it will generate equivalent FetchXML, OData, JSON formats, etc.

The tool has saved me personally 100s of hours… and world wide I am sure it has saved customers, partners, consultants, developers *millions* of hours… considering standard billable rates, the cost savings are enough to fund research into life saving treatments many times over or to feed thousands of children in developing nations.

Why do I mention…

View original post 218 more words

Activity Logging – Dynamics 365 Apps

Microsoft 365 Security and Compliance Center – provides easy access to the data and the tools to manage the compliance need of an organization, and also can be used to review the different data processing activities within Dynamics 365 Customer Engagement apps.

It required Microsoft 365 E3 or E5 subscription and is only available for Production environments.

The events logged are –

CRUD, Export to Excel, SDK Calls.
CRUM and backend activities performed by the support engineer.
Report – viewed, exported, multimedia assets shown in the Report

For this first Auditing needs to be enabled in the environment.

Navigate to Settings > Administration > System Settings > Auditing Tab

Navigate to Compliance Center

https://protection.office.com/

Search > Audit Search Log and
Turn on auditing.

To try the new experience within the Compliance center

https://compliance.microsoft.com/auditlogsearch?viewid=Search

After around 1 hour or so, the settings got enabled.

As specified Office 365 logs are being prepared, if we try searching we’d get blank results

Below are the list of Dynamics 365 and Power Apps activities that can be tracked

Around after 3 hours or so – we saw the results appearing.

Export has 2 options –

Save loaded results –

Download all results –

At the same time there we 51 records in Audit Summary View.

Apart from searching for an audit log, we can also define an audit retention policy as shown below

Get the sample files here –

https://drive.google.com/file/d/1akifraP1NCV-KgmA-8ROhm8r4h0tAcLi/view?usp=sharing

https://drive.google.com/file/d/1s_EbJ4hraDl6YEVUCMkOe6bQbXCJu_5-/view?usp=sharing

Get all the details here

https://docs.microsoft.com/en-gb/microsoft-365/compliance/search-the-audit-log-in-security-and-compliance?view=o365-worldwide

Hope it helps..

Azure Cheat Sheet

Microsoft Azure Articles..

View original post

Check access to a record in Dynamics 365

Using the Check Box button in the command bar, the user can now check the privileges he has on the record.

It also provides the details on how he has that particular privileges on the record, either through Security Roles assigned directly or through the team user is part of or through the Hierarchy security.

To see it in action, open a record and select Check Access

E.g. the below user has Read, Write, Create, Delete, Append, Append To, Assign, Share rights on the contact record, assigned directly as he has the system administrator role.

The admin user can also use the User lookup to check the access of the other users.

Here the test user 1 has rights to the record through the security roles assigned to him directly and also through the team he is part of.

Get all the details here –

https://docs.microsoft.com/en-gb/powerapps/user/access-checker

Blog posts on 2021 Release Wave 1 – Dynamics 365

Hope it helps..

In-app or Push notification – Model-driven App – 2021 Release Wave 1 Power Apps / Dynamics 365

With 2021 Release Wave 1, the in-app notifications feature has been added to the Model-driven app, earlier it was only available for Canvas Apps.

To see it in action à

https://us.flow.microsoft.com/en-us/

Create a new flow, select start from blank – Automated cloud flow, make sure the appropriate environment is selected.

Specify the flow name along with the trigger

Here for the trigger, we have specified the condition as contact creation.

For the action, select Send Push Notification V2 (preview)

For Mobile App, we can select either Power Apps or Field Service app to send the notifications to.

Here we have selected Power Apps mobile app.

Your app field will list down all the Model-driven apps available for the environment.

In recipients specify the email address and define the message.

In the Open App option, we can specify whether to open the app or not, on tap of the notification.

Finally, we can specify the entity, form for that entity (or view) to be opened.

We are setting the record id (of the contact record created) that should be opened in the form.

Save the flow.

Creating a contact record will trigger the flow and will send the notification to the mobile as shown below.

We can click on the notification, which takes us to the record as shown below.

Get all details here

https://powerapps.microsoft.com/es-es/blog/now-available-model-driven-app-push-notifications/

Blog posts on 2021 Release Wave 1 – Dynamics 365

Hope it helps..

How to – Clone A Record

Microsoft Dynamics CRM / 365

Clone A Case Record :

Cloning is one of the methods which can reduce the time spent on data entry, particularly if the same case record data being entered is similar.

Cloning or Record Copying allows you to create a duplicate record with the same values as the parent record with just one click.

Solution as follows:

Ribbon Button will be visible on the case form, Once Record is Saved , then Button will be visibled. If he click on the Button open a dialog, with message “Do You want to clone a a case Record” If he click Ok , It will Cloning the record.

flow – Button – click- Js pass Id to – Action InputParameter- Plugin Trigger – Create Case record.

Ribbon workbench Button as follows :-