Category: Flow

  • Power Automate: contains(), array, AI and bananas.

    Issue I was modifying my custom environment creation automation today. For the security group creation action, I needed to add a System Admin to the security group owners to simplify a user management. The action takes the array like below: First, I tried appending a System Admin value to the Owners array without making any…

  • Microsoft Entra ID connector – least privilege

    The solution described in the article is not fully working to the level it satisfies the author. It’s a continuous effort to come up with the best solution that meets both dev and ops requirements. Me The problem I am trying to create a security group using Power Automate using the Microsoft Entra ID connector.…

  • Power Automate w Word Online: generate document updates

    Scenario: My client generates a summary document for applications lodged online. The generated summary could be manually edited by an officer. At the final stage of the application processing, it’s required to include additional information to the generated summary document regarding the outcome of the application. This information must be dynamically generated. This is a…

  • Getting data from a function in an on-prem SQL server via Gateway in Power Automate

    Originally posted on CloudMinded: “We are screwed!” me at the moment of technology induced panic That was the feeling when I saw the below error messages. The client’s setup is an on-prem SQL server exposed to the cloud via an on-prem Gateway. It works perfectly fine for exiting Dataflow integration, but this time we needed…

  • Import solution to CDS. Missing Connection references error…

    In the morning i tried to bring back some stuff from UAT. When I tried to import my solution back to DEV I was getting errors. My solution contained Flows. Why do I use the classic admin interface to import solutions? Read this article: https://wordpress.com/block-editor/post/msolenacrm.blog/1608 I went the classic interface to import the solution. I’ve…