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
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
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
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
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
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.

<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 Power
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
Text Splitter | PCF Gallery β€” pcf.gallery
A control to split a text based on a custom separator.

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

1 comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: