Use Power Automate to maintain Top Parent Account in account hierarchies

2020-12-302020-12-31 ~ Jonas Rapp ~ 2 Comments

Using account hierarchies in Microsoft Dataverse (XRM, you know) is super easy with the out of the box Parent Account fishhook relationship.
This article will demonstrate how to maintain information about the Top Parent Account on all accounts, using a single Power Automate cloud flow.

Continue reading →

A Pro Code Escape in Power Automate

2020-09-102020-09-22 ~ Jonas Rapp ~ 5 Comments

Microsoft Power Automate is a fantastic platform when it comes to low-code automation, with connectors to literally hundreds of data sources.
But what if you need to do something too complex for the existing flow actions?
**Take the Pro Code Escape with the Common Data Service.**

Continue reading →

Querying date intervals in the Common Data Service

90 days from now

2020-06-012020-08-21 ~ Jonas Rapp ~ 13 Comments

Querying date intervals in Microsoft Common Data Service, Power Apps and Dynamics 365 is not always possible using Advanced Find nor is it as easy as working with plain SQL.

TL;DR – with FetchXML this is quite possible!

Continue reading →

Avoid nested conditionals in Microsoft Flow by using Guard Conditions

Flow nested conditions

2019-03-222020-08-21 ~ Jonas Rapp ~ 6 Comments

After working as a developer for a quarter century I have seen my fair share of nested conditionals and probably caused way beyond my fair share.
Nested conditionals make the code harder to read and simply less aesthetic.

Continue reading →