Master converting JSON to a human-readable format using code-only connector with our simple three-step Power Automate flow, perfect for any data presentation needs.
Tip #1456: Enumerate and extract JSON object properties
Use Extract JSON code only connector to select only a subset of object properties matching specified regular expression.
Tip #1454: Azure Blob metadata and index tags in Power Automate
Access blob metadata in two steps: get SAS URL then HTTP request: HEAD to read or PUT to write.
Accessing blob tags is not that easy but get your SAS key that allows tag manipulation elsewhere then come back and finish the job.
Tip #1451: Aggregates in Power Automate
You don’t need an external service to create a fast, robust, and useful custom connector. In this post we demonstrate csv to json conversion and calculations or the aggregates. Source code is available: https://github.com/georged/code-connectors.
Tip #1449: Formula columns love calculated columns
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 […]