Business Applications, dynamics 365, Model-driven

Dynamics 365 Sales Pro Trial Setup

Go to: https://trials.dynamics.com/ Let's create your Sales Pro trial in these easy steps (below). Go to trial page to set up trial Scroll down to the highlighted option. Choose for dev purpose option No, continue signing up Create a new account instead Tell us About yourself section. Add details. Enter your phone. Use Verification code.… Continue reading Dynamics 365 Sales Pro Trial Setup

Business Applications, dataflow, Dataflow, Dataverse, Flow, power automate

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

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

CloudMinded Blog

“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, dataflow, Model-driven

Dataflow for Power Apps: query CDS with OData connector(improved)

Recently I posted about the same issue: https://wordpress.com/post/msolenacrm.blog/1580 . Yesterday I discovered a new way. It looks like OData connector is more friendly than the Web API one. Use FetchXmlBuilder to help you to build the query. Start creating you Dataflow: For the data source on the tab Other pick up the OData connector. For… Continue reading Dataflow for Power Apps: query CDS with OData connector(improved)

Business Applications, Common Data Service, Flow, power automate, Power Platform, Uncategorized

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

Business Applications, Common Data Service, dynamics 365, Dynamics 365 - new UI

Dynamics 365 solution error - Components are missing, import the managed solution with these Components (Active)!

I was importing my unmanaged solution then the error has occurred. I was using a new UI. After spending some unpleasant time researching and trying different things I came across this post in the Hosk's blog: https://crmbusiness.wordpress.com/2020/06/02/dynamics-365-solution-error%e2%80%8a-%e2%80%8acomponents-are-missing-import-the-managed-solution-with-these-components-active/ Thank you very much, Hosk, you are truly marvelous! I realized that I have to switch to the… Continue reading Dynamics 365 solution error - Components are missing, import the managed solution with these Components (Active)!