Category: Flow

Co-pilot, Flow, Power Automate, Uncategorized

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

Olena Grischenko (she/her)

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: [ "https://graph.microsoft.com/v1.0/users/24d2bbbb-ae82-4d3e-8520-081231b0edc0", "https://graph.microsoft.com/v1.0/users/21d2aaaa-ae82-4d3e-8520-081231b0edc0"] First, I tried appending a System Admin value to the Owners array… Continue reading Power Automate: contains(), array, AI and bananas.

Flow, Power Platform, Power Platform Admin and Governance

Microsoft Entra ID connector – least privilege

Olena Grischenko (she/her)

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.… Continue reading Microsoft Entra ID connector – least privilege

Flow, Power Automate, Uncategorized

Power Automate w Word Online: generate document updates

Olena Grischenko (she/her)

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… Continue reading Power Automate w Word Online: generate document updates

Business Applications, dataflow, Dataflow, Dataverse, Flow, Power Automate

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

Olena Grischenko (she/her)

Dataflow magic in Power Automate. SQL with Power Query in Power Automate. Did you know you can do this?

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 data from a function in Power Automate.

Now problem, you can use SQL server connector, right?

Almost (but yes, if you read this post or knew before).

Set back #1

You cannot use “Execute a SQL query (V2)” with an on-prem gateway connection. Not supported!

Sure, let’s then use “Execute stored procedure (V2)”.

Set back #2

Apparently, you cannot return dataset from the function. Can call it if it was just a function or procedure without return value. But if it returns data – bad luck!

Panic mode on!

Wait, but what if…

Power Query to the rescue! Again.

View original post 159 more words

Business Applications, Common Data Service, Flow, Power Automate, Power Platform, Uncategorized

Import solution to CDS. Missing Connection references error…

Olena Grischenko (she/her)

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… Continue reading Import solution to CDS. Missing Connection references error…