Business Applications, Common Data Service, Flow, power automate, PowerApps, Uncategorized

Power Automate: PARSE JSON action with value or null

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

Uncategorized

Get Count of records retrieved in CDS connector in a Flow | Power Automate

I am always forgetting this expression …

D365 Demystified

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.

Scenario

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

Check Count

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)

  1. This is my List Records action and I’ve named it as Get All Records.
    defaultListRecords
  2. 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)
    initVar
  3. So, in the expressions to set the Variable, under Dynamic…

View original post 163 more words

Business Applications, Common Data Service, dynamics 365, Dynamics 365 Portals, PowerApps Portal, Uncategorized

Power Apps Portal Maintenance: The curious incident of the naughty user.

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.

PowerApps Portal, Uncategorized

Power Apps Portal: Summon the Custom Error Page to test a custom layout

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

Flow, No-code vs Code, power automate, Uncategorized

Power Automate for CDS: “what was it before we run the update?” or “bye,bye, no-code!”

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!”