Power Platform Developers Weekly – Issue #10

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

🔊 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

This is a golden nugget of info for #PowerApps Performance @rezadorrani just gave. Don't use First(Filter()) if you are returning a single item! Use Lookup Instead, much faster! #O365Nashville pic.twitter.com/OmH9RlMXf0

— April Dunnam | MVP | #PowerAddict (@aprildunnam) May 8, 2020

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