Power automate is endless fun! Today we are going to explore a very "simple" issue which are 2 issues actually: how to define "allow null" in a schema to avoid annoying errorshow to get away with the 1. without the painful consequences Let's start from the beginning! PARSE JSON is a very useful action and… Continue reading Power Automate: PARSE JSON action with value or null
I am always forgetting this expression …
In several applications, you need to know how many record were retrieved in the List records Action in a Common Data Service connector in order to take a decision.
Typically, let’s say I know only 1 record should exist in order to take that record forward and do an action. But how do I know when only 1 record was received? That’s when you use Control
Now, let’s say you want to want to retrieve Accounts and know how many were returned (Perhaps, you want to proceed only if at least 1 or more were retrieved)
- This is my List Records action and I’ve named it as Get All Records.
- And just to display how many records are retrieved, I’ll use a variable. Usually, you would use this in condition (which we’ll get to in a bit)
- So, in the expressions to set the Variable, under Dynamic…
View original post 163 more words
In the last article here I proposed the design for the custom Maintenance functionality: https://msolenacrm.blog/2020/06/20/power-apps-portal-summon-the-custom-error-page-to-test-a-custom-layout/ After the serious testing we discovered that the solution works, to some extent. For the naughty user ignoring our warnings to leave the portal during maintenance, it is possible to stay on the cached web page, go for a coffee… Continue reading Power Apps Portal Maintenance: The curious incident of the naughty user.
There is an article in Microsoft docs on how to set up the Custom Error page for the Power Apps portal. You can read about enabling here: https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/view-portal-error-log#enable-custom-error And about setting up your custom design here: https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/view-portal-error-log#display-a-custom-error-message The requirement: set up a Custom Error page for the Power Apps portal. Easy! First, you go and… Continue reading Power Apps Portal: Summon the Custom Error Page to test a custom layout
The requirement: for Account(Property in our case) if related Contact(Tenant) is "un-linked", create a Note. No-code solution: none. Why? These are triggers available for CDS(current environment): CDS current environment triggers We choose Update trigger for Contact filtering by parentcustomerid ... and this is it. This is where our no-code journey ends. When Update triggers on… Continue reading Power Automate for CDS: “what was it before we run the update?” or “bye,bye, no-code!”