Power Fx Functions for Collection Shaping in Canvas App | Beginner's Guide

In this article, we will explore how Power Fx functions such as ShowColumns, AddColumns, RenameColumns and DropColumns can be used to shape your collection and streamline your workflow. These functions are powerful tools that allow you to manipulate data with ease.

To make this tutorial more contextually relevant, we will examine these functions within the context of a simple scenario. We will create a Canvas App and add a Dataverse Contact table as a DataSource. From there, we will demonstrate how these functions can be used to transform the data in the Contact table to a Collection.

The first function that we will explore is ShowColumns. This function is instrumental in creating a collection that only includes specific columns of data. Next up, we will dive into AddColumns and explore how this function can be used to add new columns to your collection based on existing data.

Then, we will move on to RenameColumns which, as the name suggests, allows you to rename existing columns in your collection. Finally, we will examine DropColumns which lets you remove specific columns in your collection that are either irrelevant or redundant.

If you are a Power Fx beginner looking to explore these functions, this article will serve as a comprehensive guide to get you started. With a clear understanding of how these functions work, you'll be able to streamline your data workflows and transform raw data into powerful insights that drive your organization forward.

The post [Beginners] Power Fx: ShowColumns, AddColumns, RenameColumns and DropColumns first appeared on Rajeev Pentyala - Dynamics 365 Blog.