Update Data in your CDS using Azure SQL Server, Azure Functions or Connectors from SQL Data

Recently, while working on a project that needed to update the Exchange rates in CDS, I was tasked at finding a solution that would be able to retrieve data from a SQL Server hosted on an Azure Virtual Machine. There were so many different approaches, and security was the main one, but I decided to do a deep dive and testing out how Power Automate will be able to accommodate these requests.

Microsoft Forms Pro is becoming Dynamics 365 Customer Voice

In late July, during Inspire 2020 event, Microsoft made an announcement about the upcoming changes to their forms and survey application (Forms Pro), and rebranding this as a completely new product Dynamics 365 Customer Voice.

Email enhancements in 2020 Wave 2 Release Plan

With the release of Microsoft Dynamics 365 and Power Platform 2020 Release Wave 2, Microsoft has made several enhancements related to the email experience in model-driven apps. This post will cover the email file attachment enhancements as well as the new experience for email templates.

Document Generation Enhancements in 2020 Release Wave 2

With the release of Microsoft Dynamics 365 and Power Platform 2020 Release Wave 2, Microsoft has made some enhancements to the document generation capabilities and file attachments in model-driven apps. This first post will cover the document generation capabilities and the generation of pdf documents based on document templates.

Customer Service Workspace (Preview) in 2020 Wave 2 Release Plan

For anyone who has experience with Microsoft Omni channel interface, and has enabled the 2020 Wave 2 Release Plan, there is a new app that appeared with the name Customer Service Workspace (Preview). As noted in the release plan, the multisession app allows customer service agent to multitask on several customer cases simultaneously and seamlessly switch among issues without losing context of the in-progress work.

Sending Emails to all customers using Power Automate

Recently in the forums, there were a few questions on how to send emails to all of my customers. While there might be different options, and the right solution to this might greatly depend on the frequency that you need to be sending this as well as the number of contacts, I thought I would demonstrate a few different approaches to implement this using Microsoft Power Automate.

AI Builder Business Card Reader

I have started working with AI Builder recently and yesterday I finally took a look at the Business Card scanner. I decided to check how this works in the different apps, both Modal Driven as well as Canvas Apps.

I ran my tests using 4 different types of business cards and wanted to see how well this works. The results overall were pretty good, but not perfect. It is still hard to expect perfect results, as not all Business cards are created equal.

T-SQL Endpoint for Common Data Service

Since the announcement by Microsoft at the Microsoft Business Applications Summit last month, and even before, I’ve been eager to take a look at the new SQL Connection for the Common Data Service Endpoint. What this means is that we can not write and execute SQL queries against the entity data.

Showing page status of multi-page forms in Power Apps Portals

Creating navigation in a Power Apps portal application is straight forward, and can easily be done using Web Link Sets, but how about showing to the user where they are in the process and modifying the style of each element once the user has finished entering the data for that page. We have done this a few times and this involves the combination of liquid and JavaScript code on the different pages.

Changing record statuses in UCI and 2020 Wave 1 release

When working with model driven apps, we have the ability to navigate through the flow of the record using the Business Process Flow. The BPF is a great way to navigate through the different stages of the record, but what if that is just not enough. What if in order to complete the record I have to go through 10 or maybe more stages.