Tip #1445: Date picker in Power Pages revisited

The image displays the Aztec calendar stone, also known as the Sun Stone, featuring intricate carvings. The calendar is a large circular stone with detailed mythological and astronomical engravings that played a significant role in the Aztec civilization. The central face of the sun god Tonatiuh appears at the center, surrounded by elaborate designs that represent different periods of time and the cosmos according to Aztec beliefs. The stone is showcased against a plain backdrop, emphasizing its historical and cultural significance.

The product has been renamed at least twice since we talked last time about how to restrict the date picker control in now Power Pages. But most importantly that code, according to some reports, no longer works. Fear not, here’s the revised version that works perfectly well in Power Pages (it did 5 minutes ago, […]

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 #1442: Security for beginners

A Microsoft open-source course on security for beginners: An individual studies atop a giant book emitting a glowing lock. Surrounding icons represent various security concepts. The course covers common security threats, Zero Trust, SecOps, and Application Security. Learn more. 📚🔒🌐 #CyberSecurity #Learning

We talk about security around Dataverse and Power Platform from time to time. We even dabble into platform agnostic security tips. Today is all about vendor-agnostic cybersecurity. Learn the fundamentals of identity management, zero trust, AppSec, and data security in this new 7-lesson open source course, “Security for Beginners” created by Microsoft Cloud Advocates. Each […]

Tip #1441: Owner is a user is a team

Team members

WARNING: Niche L400 tip ahead. tl;dr If you’re expect primary column name to be tablename + “id“, add an exception for systemuser and team tables – both will come back as ownerid in custom API. L400 If custom API has an output property of type EntityReference then, for example, for account (or any other “normal”) table, the […]

Tip #1440: Relative dates in sample data

Import Excellence Award

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 […]