Azure Development, Azure Integration, Business Applications, Dataverse

Simple Azure Invoice OCR Tutorial

We are exploring OCR capabilities for invoice processing. This is the article which may help you to understand how it work if you want to train a custom model to use it then with Power Automate. Do you want your own OCR which costs less than a coffee? All credits go to Nick Grischenko.

Azure Integration, Business Applications, Common Data Service, Power Platform

Azure Storage integration for Power Apps portals

To answer the question Why? I say we run into some limitations with SharePoint integration. And now we are trying to explore other options. Let's get started! Enable Azure Storage This is a great blog post here: Want to leverage Azure storage for your documents in PowerApps/ Dynamics 365 portals instead of Notes? Check this… Continue reading Azure Storage integration for Power Apps portals

Business Applications, dynamics 365, Dynamics 365 - new UI, PowerApps

How do I pass executionContext as a parameter into my Promise to fit in Promise.all()?

To be honest, this post should be a bit longer with more details but I like it this way. This is a sample below. It looks cool. And I building one of my own. But I need it to work with my onSave form validation. const promise1 = Promise.resolve(3); const promise2 = 42; const promise3… Continue reading How do I pass executionContext as a parameter into my Promise to fit in Promise.all()?

Business Applications, dynamics 365, Model-driven

Dynamics 365 Sales Pro Trial Setup

Go to: 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