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