🥇 Cover Story

How to bring external data from SQL Server tables into your Model-driven Power Apps with the new Virtual Connector Provider.

💎 Model Driven Apps & Dataverse

Temmy explains us three different strategies available to us when developing processes in Dataverse. Check out the verdict of the comparison.

Connecting to Dataverse using PowerShell can be very helpful for data migrations and use within Azure DevOps.

Teams integration is enabled on some out of the box entities but you have to perform some steps to enable them on custom entities. Ajit shows us how that can be done.

🏋️‍♂️ Canvas Apps

With the Power Apps barcode scanner you can quickly make apps that turn any mobile device into an inventory management tool.

This post showcases how to use the behavior property for components in canvas apps which are in preview as of now.

Lessons from Joy on a real-life production use case for offline architecture in canvas apps. Part 2 of 2.

🐱‍🏍 Power Automate

Not all cloud flow executions are completed successfully. Ashiq in this post shows us how to handle different failures so your flows don't end abruptly.

In this blog, we will see how to read the parameter from the URL in Power Automate.

The activities have a field named Regarding which is of type Multi-table lookups. This post will discuss how to get the type of lookup populated on the Regarding field during execution of the cloud flow.

🚀 Power Apps Component Framework (PCF)

In this blog, we will learn how to Read and Set the Date Format of Logged-in Users in PCF Control.

When executing MSBuild commands from VS Code you often see an error. This post explains you how to get that error resolved.

👍 Everything else in Power Platform

In this post, I am gonna show you how you can enable Actionable Adaptive card to be able to render on the recipients outside of your domain.

👩‍💻 Dev to the Core

Remotely browse and edit a source control repository from within Visual Studio Code.

⛅ Around Azure

In one of Nishant's projects, they were executing SSIS Packages under Azure-SSIS Integration Runtime in Azure Data Factory. The steps they took for optimization are noted by Nishant in this post.

🎮 Other Interesting Articles

You might be getting unwanted tables in your solutions – here is one reason why - Alex Shlega

Get started with child flows in Power Automate - Pieter Veenstra

Modern Model App designer (preview) – Dataverse - Nishant Rana

Retrieve EntityMetadata via Odata WebApi - Dineshkumar Sivakumar

Canvas App Automated UI Testing - Rami Mounla

🎥 Videos

🐤 Tweets of the week

Raphaël Pothin 🐼 Microsoft MVP @RaphaelPothin

@BergmannBene and I are really happy to share that a first milestone has been merged in the https://t.co/YLjdrZxgnE repository 🥳 It covers the provisioning and decommissioning of a #PowerPlatform environment from #AzureDevOps. #DevOps #ALM

1:05 AM ∙ Jan 19, 2023

💖 Sponsors

Thanks to the following people for being the sponsors:

🥇 Gold - Sudhakar Deenadayalan

🥉 Bronze - Linn Zaw Win

You can also be my sponsor. More details can be found here.

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

Are there certain kinds of content you’d like to see here? Let me know what you think on survey.