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

Dataflow, Dataverse

Dataflows for Power Apps: calling a table-valued SQL function with Power Query

It's very easy to query SQL table-valued function to retrieve the result with Dataflows. This is how we do this. Let's connect to a database. It will work via gateway as well. Select your function. Pass the parameter if required. Now you can use this table to merge with other tables or map and load… Continue reading Dataflows for Power Apps: calling a table-valued SQL function with Power Query

Dataflow, Dataverse, Model-driven

❤ Dataflows for Power Apps ❤: “The column ‘[Column_name]’ of the table wasn’t found.” error while loading multiple tables

There is an option to load data to multiple table in one go in Dataflows. These tables can be related. Dataflow engine calculates the dependencies and determines the correct order for loading. It's a very cool functionality, however, you have to be aware of some potential issues as well as available workarounds. Problem: I am… Continue reading ❤ Dataflows for Power Apps ❤: “The column ‘[Column_name]’ of the table wasn’t found.” error while loading multiple tables

Azure Development, Custom Connectors, Dataverse, power automate, Uncategorized

Azure Functions in Power Platform multiple environments

Working with real customer’s deployment requires managing multiple environments – at least Test and Production or additionally a Dev environment. One of the common patterns we use in the solutions is to use Azure Functions as an effective, serverless extension of the point-and-click Power Automate flows. This pattern utilises a Custom Connector created to embed the function call and parameters into… Continue reading Azure Functions in Power Platform multiple environments

dataflow, Dataflow, Dataverse, PowerApps, Uncategorized

Dataflows for Power Apps: transform fixed-width text files

What is a fixed width text file? Data in a fixed-width text file is arranged in rows and columns, with one entry per row. Each column has a fixed width, specified in characters, which determines the maximum amount of data it can contain. No delimiters are used to separate the fields in the file. Could we load data from… Continue reading Dataflows for Power Apps: transform fixed-width text files