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 #1415: Call Excel functions from Power Automate
If you know Excel you’ll be very comfortable with Power Automate, they said. Except most of the Excel functions do not even have an equivalent in Power Automate. But what if we could access all Excel functions in Power Automate? Say no mo In the Episode 13 of Citizen Can Amey and George talk about […]
Tip #1414: Enforce unique email but ignore inactive records
Alternate keys are great way to enforce uniqueness of the column values. For example, if you want lead emails to be truly unique, just add an alternate key and no user will be able to bypass that (unlike the duplicate detection which is a fairly timid mechanism). The challenge is when you want that uniqueness […]
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 […]
Tip #1410: 50 Shades of Regex
I usually don’t drool over code but this one is just way too elegant for me not to. StackEdit – In-browser Markdown editor is an awesome app for markdown editing. One of the standout features is ability to comment and review – something sorely missing from the standard markdown. StackEdit very cleverly serializes reviews and […]
Tip #1409: Count records for all tables in Dataverse
Want to count all records in all Dataverse tables like a boss? Say no mo. Make sure TDS endpoint is enabled using Manage feature settings. Connect to your Dataverse as described in Use SQL to query data (Microsoft Dataverse) We cannot use some of the features including loops (see How Dataverse SQL Differs from Transact-SQL) […]
Tip #1408: When tomorrow comes in Power Automate
Ever wondered how to use Dataverse date filters like “Today” or “Tomorrow” when listing records in Power Automate? Yes, plonking in the entire FetchXML with <condition attribute=”enabler_stamp” operator=”tomorrow” /> is one way to handle that. The other is to use query function Tomorrow in the filter: Microsoft.Dynamics.CRM.Tomorrow(PropertyName=’enabler_stamp’) Here’s the catch: “tomorrow” is relative. If you live anywhere west […]
Tip #1407: How to secure Power Apps portal from making the news
You are a CEO of Rykita, a worldwide manufacturer of power tools used by millions. You wake up invigorated and ready for action only to see the news headlines “Rykita injures more than a thousand customers”, “Calls for Rykita to blunt their tools”, “Rykita customers bleed profusely”, “Users of Rykita tools risk infection if injured”, […]
Tip #1406: Flow history takes long time to load
Cover photo by invisiblepower from Pexels
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 […]