Can’t return the data type you need from a formula column? Do your homework then create a calculated column that simply casts to the correct type.
Tip #1446: Empty array in Power Automate
To create an empty array in a Power Automate formula, just use json(‘[]’). That’s it — there’s your entire tip.
Tip #1445: Date picker in Power Pages revisited
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 #1441: Owner is a user is a team
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 #1433: How to list all Dataverse tables in style
Is there any way to export automatically or with a script a list of all the Dataverse tables in an organisation? From our good friend Shan McArthur came a multilayer answer (narrated and illustrated by The Enabler): One: We have a virtual entity called entities that will give you a list of all entities in […]
Tip #1421: Hide form selector in model-driven apps
Everybody take a seat. Tanguy WiTouzard has the floor. (You can grab everyone’s attention too by sending your useful tip to jar@crmtipoftheday.com) Wizardry starts here I don’t know if it was published before but I just found out that we were able to remove “forms” from “form selector” using Javascript. It’s really useful when you […]
Tip #1420: JSON Function and size limits in Power Apps
Power Fx (gotta use the cool keyword!) JSON function in Power Apps is pure magic, it’s like a compactor converting anything you throw into it into a neat text representation to send over the wire, engrave on a golden bullion, or stash it as an alphabet soup. It works great apart from the times when […]
Tip #1418: In-app notifications in model-driven apps
Welcome to inaugural video shorts where all human knowledge is compressed into the bites of 60 seconds or less, to be consumed while waiting for the paint to dry. In this episode we help Lisa to enable in-app notifications in model-driven Power Apps without any code using a freshly baked XrmToolBox tool by Ivan Fricko. […]
Tip #1416: Power Platform PowerShell module includes unapproved verbs
tl;dr No, Power Platform team didn’t sneak in any profanities into PowerShell module. It’s caused by the verb Apply, is by design, and can be safely ignored. Longer version I usually oblivious to any warnings produced by the command line tools. My attention is fully reserved for the word FATAL in Ferrari red (#ff2800 if […]
Tip #1411: Power Apps portal vulnerability checks using PowerShell
I’ve created couple scripts that quickly check if your Power Apps portal has a potential vulnerability in the portals I look after. OData Endpoint Probe This one is quite trivial and simply probes the OData endpoints exposed by the portal. Takes portal url as a parameter and lists all OData endpoints. Endpoint is marked as […]