Tip #1453: Open the tools like a pro

Discover how to effortlessly access the latest Plugin Registration Tool and Configuration Migration Tool directly from your console.

Tip #1450: Create Dataverse app users like a boss using pac cli

An ethereal human hand radiates with a brilliant blue glow from the center of its palm, positioned above a computer monitor that displays lines of code. The background is black, dramatized by radiant white beams emanating from the hand and spreading outward. The hand appears to be invoking powerful digital magic, suggesting command over the computer and its software. The scene conveys a sense of authority and control within a technological context, emphasizing the power of digital creation and manipulation.

Creating an app user is now as simple as running “pac admin create-service-principal” command.

Tip #1448: Never delete columns in translation

The background of the image is a blurred office setting with a clear focus on a large, slightly angled Excel spreadsheet in the foreground. The spreadsheet is filled with columns containing multilingual text to symbolize translations in Dataverse. One of the middle columns is highlighted with a dramatic red overlay and a bold prohibition sign (a circle with a diagonal line) to catch the eye immediately, symbolizing the rule against deletion. Above the spreadsheet, in a cautionary yellow, the text reads: "Caution: Never Delete Columns!" with a subtitle saying, "Essential Dataverse Translation Rule" to provide context to the viewer. The prohibition sign is mirrored in the upper corner of the image for added emphasis, and there's a faint overlay of a globe made up of various national flags on the lower side of the spreadsheet, indicating the international nature of translations. The overall color scheme uses stark reds and yellows against a professional, muted background to grab attention and convey the seriousness of the message. The design balances a professional tone with the dramatic flair needed for social media engagement.

Dealing with Dataverse translation file? Never delete columns. But you are free to delete rows and tabs.

Tip #1443: Let SharePoint deal with rogue data

The image depicts a flowchart illustrating the process of importing data into a SharePoint list using Power Automate, highlighting the challenges of handling 'dirty' data. The diagram shows the initial data import encountering errors symbolized by warning signs, due to non-standard or 'dirty' data. Subsequent steps demonstrate the use of Power Automate to clean or filter out these errors, with symbols like checkmarks indicating successfully cleaned data. The overall image conveys a journey from obstacle-laden data processing to achieving a streamlined and efficient import process, emphasizing the transformation from 'dirty' to clean, usable data.

Using Power Automate to import data into an existing SharePoint list is fairly straightforward, except when the data isn’t very clean. For instance, if a number column contains blank values or some non-numerical garbage, SharePoint connector will flip out. OpenApiOperationParameterTypeConversionFailed The ‘inputs.parameters’ of workflow operation ‘Create_item’ of type ‘OpenApiConnection’ is not valid. Error details: Input […]

Tip #1440: Relative dates in sample data

We all enjoy flexing our Dataverse or Dynamics 365 skills from time to time. Many of us have meticulously crafted a demo instance from proverbial stone and blood. However, one of the challenges is keeping the data up-to-date. There’s nothing worse than displaying 20 tasks that are all overdue by four months. Fortunately, Dataverse offers […]

Tip #1425: Dataverse CSV import using alternate keys

Today’s tip is from Alex McLachlan (@alex_mcla), saving the day (no kidding – I used it the very next day after receiving the tip). You can be a hero too by emailing your tip to jar@crmtipoftheday.com! With the classic import experience, you couldn’t use a CSV import containing an Alternative Key column to update existing […]

Tip #1424: The user does not have sufficient access right to run flow with custom connector

I’ve tried all the right things: Created, deployed, and configured custom connector into the target environment before importing the solution that uses the connector. All tests pass. Created a manual Power Automate flow as part of the solution. Shared the flow with the user (should not need to for the solution flows but just in […]

Tip #1405: Unable to assign license to a guest user

B2B collaboration is great. For example, you can share a canvas app with guest users or invite users to use with Azure Active Directory B2B collaboration . One of the steps in the process is adding B2B collaboration users in the Azure portal. But when you try adding a license assignment you maybe faced with […]

Tip #1400: Excluding inactive records from duplicate detection

It’s good to be reminded every now and then about the features that have been around for a long time and are documented but somehow any question from the business about them draws a blank and ubiquitous “I have to get back to you”. Today’s reminder is from Ankita Chavan. (Do you use a feature […]

M	T	W	T	F	S	S
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28

Power Platform
Dynamics CRM

Tip of the Day