Want to get newsletter to your mailbox? Subscribe here


During MBAS, Microsoft announced CDS T-SQL, a way for us to use SQL to query the data. This feature is in preview and you can read more on Microsoft Docs. Another nice thing on Microsoft Docs is the guide to implement ALM with Power Platform.

Some new changes to the newsletter, one story will be highlighted as a “Cover Story”. Also, I have added a new category called “Tweet of the week” – some tweets are not articles but tips which are really useful.

– Danish N.


 Cover Story

CDS T-SQL Endpoint pt. 1 - Connecting - Mark Carrington
CDS T-SQL Endpoint pt. 1 – Connecting – Mark Carringtonmarkcarrington.dev

Microsoft have added a (preview) way of querying your CDS data using T-SQL, which anyone familiar with SQL Server will already know.

 Power Platform Updates

Capture signature in PowerApps Portal - Dancing with CRM
Capture signature in PowerApps Portal – Dancing with CRMwww.dancingwithcrm.com
Learn how you can capture and view signature in Power Apps Portal


Power Apps Portals – Adding Icons to Entity List Action buttons via CSSoliverrodrigues365.com

For a nicer UX, I will show you how to display the actions as icons within the list row.


Power Platform DevOps: Part 5 – Deconstructing the Frameworkdylanhaskins.com
Deep dive into the details of the PowerApps and Power Platform DevOps tools and scripts that we use to provide our Application Lifecycle management.

 Common Data Service


Upgrading to the new CDS connector – Hardit Bhatia: The Power Addictthepoweraddict.com

Apps created prior to November 2019 would still be using the old CDS connector. To switch to the new connector, the steps are in the blog.


Dynamics 365 Email – HTML Signature and Sender – CRM Keepercrmkeeper.com

This post is a part of a series of posts for Customer Service. I need to automatically add a signature. Am I really the only one having these problems…?

Show Global Notification on Load of Model-driven App in Dynamics 365
Show Global Notification on Load of Model-driven App in Dynamics 365linnzawwin.blogspot.com

In Unified Interface, we can now show such application-level notification using addGlobalNotification client API

 Power Apps & Power Automate

How-To: Creating Multi-Language Canvas Apps
How-To: Creating Multi-Language Canvas Appslennartwoermer.de

Best Practice and tutorial how to create multi-language Canvas Apps as a type of Power Apps including administration through a Model-Driven App


Keyboard shortcuts for canvas apps – Power Apps | Microsoft Docsdocs.microsoft.com
Keyboard shortcuts for canvas apps

Control Access to Power Apps and Power Automate with Azure AD Conditional Access Policies
Control Access to Power Apps and Power Automate with Azure AD Conditional Access Policiesdevblogs.microsoft.com

Control access to these platforms by ensuring only authorized users have access to critical systems.

 Power Apps Component Framework (PCF)

PCF Dataset Paging in Model vs Canvas Apps
PCF Dataset Paging in Model vs Canvas Appswww.develop1.net

This post demonstrates how the paging API works in Model and Canvas and highlights the differences.

<img width="140" height="140" alt="Consuming Microsoft Graph API from PCF Control – Implementing Tae of ” style=”float:right;margin-left:20px;margin-bottom:20px;” src=”https://s3.amazonaws.com/revue/items/images/005/991/337/thumb/MicrosoftGraphAPInPCF.jpg?1589891873″&gt;
Consuming Microsoft Graph API from PCF Control – Implementing Tae of <T>taerimhan.com

There are often situations where data from other Microsoft 365 services are required from within your model-driven Power Apps.


Can PCFs communicate? – Dianamics Powerdianabirkelbach.wordpress.com

A PCF component is isolated in a sandbox. That’s it. I totally understand that the components has to be in “isolation”, but what if they need to “tell” more?

 Tools & Components


Text Splitter | PCF Gallerypcf.gallery
A control to split a text based on a custom separator.


Duration Picker | PCF Gallerypcf.gallery
A control to allow users to enter hours and minutes manually, by clicking the chevrons or manually entering time up to 24 hours.


Screenshot PCF | PCF Gallerypcf.gallery
A control to directly email a screenshot from a Canvas App.

 Videos

Let’s chat about the new Power Platform ALM Guidance
Power Apps – 12 UX & UI Design Tips

 Podcasts

XrmToolCast: Developer Frameworks on Projects with Scott Durow

In this episode, Jonas puts the call out for help with using frameworks on projects, so we call in Scott Durow

 Tweet of the week

 Thanks for reading

How did you like this issue? Was it useful and bite-sized? Are there certain kinds of content you’d like to see here? Let me know what you think on survey.