New format for Single Line of Text data type

New format “Json” introduced for “Single Line of Text” data type.

Search this view capability on Grid in Dynamics 365

Nishant Rana's Weblog

Search this view capability which was added in the product with 2020 Release Wave 1, searches on the fields specified in quick find view, but takes into consideration the selected view definition, when performing the search.

This is enabled by default.

Here Search this view will perform the search within the selected view i.e. All Contacts in this case.

The results show 3 records found within the All Contacts view, for the search term “alex”

The same search term returns blank in the case of Inactive contacts is selected.

The same applies to the sub-grids

To turn off this, select Yes for Use quick find view of an entity for searching on grid and sub-grids from General tab of System Settings

After applying the above change, we can see the text renamed to Quick Find within the Search Box.

Searching now, irrespective of the view selected, will perform the…

View original post 28 more words

Check user’s access to a record – upcoming feature in Dynamics 365

Nishant Rana's Weblog

Was going through the Model-Driven Apps documentation and found the below article

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

It talks about a Check access button on the command bar of a record which will list down all the rights/access/privileges on that particular record.

And also how the user has got those accesses, through security roles directly assigned or through the team the user belongs.

We can also check the access of the other users as well through user lookup.

More on Access in Dynamics 365

Hope it helps..

View original post

Process Optimization – Dynamics 365 CE / CRM / CDS SSIS Integration toolkit – KingswaySoft

Process Optimizations is a new feature added in the CDS / CRM Destination Component of KingswaySoft’s SSIS Integration Toolkit as part of November 2020 Release. Check other posts on SSIS and Dynamics 365 https://nishantrana.me/2020/10/16/ssis-kingswaysoft-and-dynamics-365/ These options if enabled, will turn off or disable plugin, workflow, entity auditing during pre-execution temporarily, during the writing process, and […]

Process Optimization – Dynamics 365 CE / CRM / CDS SSIS Integration toolkit – KingswaySoft

Disable Background Processing Mode

Recently when I am running a background process I got the below error on one of the customer’s instance.

The async operation was skipped because the org is in ‘Disable Background Processing’ mode

After a bit of research I understand, we can disable the background process execution from admin control. Follow the below steps to enable / disable background processing.

  1. Navigate to https://admin.powerplatform.microsoft.com
  2. Select the Instance that you want to make this change.
  3. Click on “Edit” to open the settings screen where you could make this change.
  4. Change the “Background operations” setting as per your requirement.

The new Column comparison in queries in Dynamics 365 / PowerApps

Nishant Rana's Weblog

Column Comparison is one of the best features that has been recently added to the product.

Column comparison allows us to compare values of 2 different columns in our query be it Fetch XML, Web API, or through SDK API.

Sharing some of the basic examples that we tried using our favorite  FetchXML Builder

  • If we run the following query “Find all contact which has the first name equal to the last name”

The result –

  • Find all contact where the first name is not equal to last name

The result –

The operators supported are –

Equal LessEqual GreaterEqual
Not Equal LessThan GreaterThan
  • Only 2 columns can be compared.
  • Only compatible attribute types can be compared.
  • E.g. “Find all contact where the first name is equal to address 1 city”

The result

It works as both are string attributes.

  • If we try comparing text field with options set, we…

View original post 111 more words