🥇 Cover Story

Check out this interesting write-up from Temmy to know how with the help of Azure SQL Server + Dataverse Custom API, you can implement a simple architecture solution to handle concurrency in Dataverse.

💎 Model Driven Apps & Dataverse

We can implement calculated columns using Dataverse formula columns (using Power Fx), and that should be the first choice. But that won't work in offline mode. Using the Power Apps Grid customizer control, Diana made it work offline too.

Microsoft is continuously working on providing a richer and seamless experience while setting up the security model. With this new feature, you can add security roles from other business units to a user besides the user’s standard business unit.

Deepesh talks about a new Power FX Formula feature preview feature in this blog.  

🏋️‍♂️ Canvas Apps

You will see in this blog how we can initiate an MS Teams call or a WhatsApp chat from a Canvas app. Also, we will use the new concept "Named Formulas" to implement this scenario.

How to Parse JSON in Power Apps with ForAll explained and how to use AddColumns to do the work much faster and in more performant way.

ParseJSON in Power Apps canvas apps, How to parse JSON text inside Power Apps Canvas apps

😎 Power Automate

Power Platform has a ( low-code ) way to find out the content of an updated or deleted record before the change. Read more to know how.

Learn how to Terminate a Power Automae flow.

🚀 PCF & Custom Pages

Check out a PCF date picker control by Andrew.

👍 Everything else in Power Platform

Read this post from Pieter to know how you can export Dataverse data to an Azure SQL database using Azure Synapse link.

You want the intellisense in your webresources project but don't want to use TypeScript? JSDocs to the rescue.

🎮 Other Interesting Articles

How to escape Double quotes (“) in Power apps canvas apps - Debajit Dutta

Execute Custom actions using sales insight cards (assistant V3) in D365 CE - Inogic

Easily Power Apps Portal Pages authoring - Mo Faheem

Formatting Section or Field Label as Bold/Italic in Model-Driven App - Linn Zaw Win

🎥 Videos

🐤 Tweets of the week

devkeydet @devkeydet

Being the impatient person I am, and knowing @RajYRaman is going to find it anyway ;), sharing that we've published the Creator Kit to AppSource: https://t.co/jCwuFe3yIe We'll update the docs as the recommended install approach "soon". Until then, feel free to try it now.

1:05 AM ∙ Jan 19, 2023

✨ Thanks for reading

If you’re enjoying this newsletter, then it would mean a lot when you share it with your friends & colleagues and ask them to subscribe to this newsletter.