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 Carrington — markcarrington.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 CRM — www.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 CSS — oliverrodrigues365.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 Framework — dylanhaskins.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 Addict — thepoweraddict.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 Keeper — crmkeeper.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 365 — linnzawwin.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 Apps — lennartwoermer.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 Docs — docs.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 Policies — devblogs.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 Apps — www.develop1.net

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

Consuming Microsoft Graph API from PCF Control – Implementing Tae of ” style=”float:right;margin-left:20px;margin-bottom:20px;” src=”<a href=https://s3.amazonaws.com/revue/items/images/005/991/337/thumb/MicrosoftGraphAPInPCF.jpg?1589891873″>;
Consuming Microsoft Graph API from PCF Control – Implementing Tae of — 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 Power — dianabirkelbach.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 Gallery — pcf.gallery
A control to split a text based on a custom separator.


Duration Picker | PCF Gallery — pcf.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 Gallery — pcf.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.