🥇 Cover Story

Following the #ProCodeNoCodeUnite movement, Power Automate and CDS allow you to embed pro-code methods in no-code automation. Let me take you through the tech of it.

👍 Power Platform

Prior to Portal Web Api, Olena remembers it was not possible to deactivate a record with a different status from the default one. Now it is super easy.

Nishant has been going deeper and deeper with Azure Data Factory and this time he shows us how to deploy and run SSIS package in Azure Data Factory.

💎 Model Driven Apps & CDS

Interesting usage of Power Automate Flows, PCF code component and some JavaScript by Alex Shlega to extend the document template feature.

Scott Durow as always enlightens us with a nice analogy of Pets vs Cattle. I am a firm believer of this process myself with some caveats 🙂.

🏋️‍♂️ Canvas Apps

Here's how you can dynamically add a column if not present in a Data Source to your Canvas Power Apps Data Table!

One common example where running totals are useful in Power Apps is when you want to display monthly sales data along with a year-to-date sum.

🐱‍🏍 Power Automate

How to determine which CDS event triggered a flow. The SdkMessage attribute in the body of the trigger contains the name of the trigger e.g. create, update.

🚀 Power Apps Component Framework (PCF)

What's the right height for the grid pcf? Diana identifies a way to determine how to set your height dynamically in a Dataset PCF control.

Alex Shlega create yet another PCF code component that will download a file on your local computer or open a file in a new tab.

🔨 Tools & Components

Thomas Dayman creates a new tool in XrmToolBox that will let you revert your changes using Audit History.

Scott Durow adds a nice feature to his Smart Buttons in Ribbon Workbench to use Environment Variables.

Guido Preite updated his 2 year old solution with some new features and support for latest Dynamics version.

🎮 Other Interesting Articles

Clarissa Gillin uses some innovative ideas to create an app that can serve infinity forms and minimizing number of components used in an app.

Want to build a quick basic ALM process for your project? Dharani shows us how to achieve that in his post.

🎥 Videos

🐤 Tweets of the week

Alan Chai | PowerApps MVP Biz Apps @alanchai

UNICODE in your #PowerBI Measures to expand your conditional formatting options. The possibility is huge... UNICODE reference table: https://t.co/1mqgb7MfFL Bring on some fun into a otherwise dull report. Better performance than having image. Same applies on #PowerApps https://t.co/xksLczJFtR

1:05 AM ∙ Jan 19, 2023

🤩 Thanks for reading

How did you like this issue? Was it useful and byte-sized? Are there certain kinds of content you’d like to see here? Let me know what you think on survey.