Uploaded October 2024 | Updated September 2026, 2 weeks ago
In this tutorial, we dive deep into the Power Apps AddColumns function and explore several other key data manipulation functions. From basic to advanced scenarios, you'll learn how to shape and manipulate data without affecting the underlying data source. Whether you're working with SharePoint, Dataverse, or SQL, this video will guide you through the process of creating dynamic tables and performing data transformations directly within Power Apps.
Key topics covered:
✔️ Introduction to AddColumns and why it’s essential for data shaping.
✔️ How to combine first name and last name into a single full name column without modifying your data source.
✔️ Handling delegation issues and understanding its impact on data functions.
✔️ Sorting on complex columns, such as favorite color using AddColumns.
✔️ Adding and renaming columns dynamically within your Power Apps environment.
✔️ Using lookup functions to bring in related data from another list, like departments and managers.
✔️ Advanced tips on reducing performance bottlenecks when dealing with large datasets.
This video is perfect for both beginners and seasoned Power Apps developers looking to improve their understanding of how to manipulate data on the fly for optimized app performance. Join us as we cover practical examples and scenarios to help you master these powerful data manipulation techniques.
Up your Power Apps Skills Today!
powerapps911.com/up-your-power-apps-skills
0:00 Power Apps Data Shaping functions
0:41 Add a gallery
1:27 AddColumns function
3:04 Sort by a choice column
4:37 Add a related column with lookup
6:45 Using AddColumns with a Collection
9:05 Add a Dynamic Date
10:44 ShowColumns function
13:21 DropColumns function
14:32 RenameColumns function
15:26 Use case ideas and the old syntax
17:13 Get a list of months
Do you need some help with something that you are working on, contact us!
powerapps911.com/contact
PowerApps911
powerapps911.com
Let's connect on social!
Twitter: twitter.com/ShanesCows
Facebook: facebook.com/powerapps911
Instagram: instagram.com/shaneyoung911
LinkedIn: linkedin.com/in/cincyshane
Join this channel to get access to perks:
youtube.com/channel/UC7_OGRP8BYvtGB8eZdPG6Ng/join
#powerapps #PowerPlatform #CanvasApps
In this tutorial, we dive deep into the Power Apps AddColumns function and explore several other key data manipulation functions. From basic to advanced scenarios, you'll learn how to shape and manipulate data without affecting the underlying data source. Whether you're working with SharePoint, Dataverse, or SQL, this video will guide you through the process of creating dynamic tables and performing data transformations directly within Power Apps.
Key topics covered:
✔️ Introduction to AddColumns and why it’s essential for data shaping.
✔️ How to combine first name and last name into a single full name column without modifying your data source.
✔️ Handling delegation issues and understanding its impact on data functions.
✔️ Sorting on complex columns, such as favorite color using AddColumns.
✔️ Adding and renaming columns dynamically within your Power Apps environment.
✔️ Using lookup functions to bring in related data from another list, like departments and managers.
✔️ Advanced tips on reducing performance bottlenecks when dealing with large datasets.
This video is perfect for both beginners and seasoned Power Apps developers looking to improve their understanding of how to manipulate data on the fly for optimized app performance. Join us as we cover practical examples and scenarios to help you master these powerful data manipulation techniques.
Up your Power Apps Skills Today!
powerapps911.com/up-your-power-apps-skills
0:00 Power Apps Data Shaping functions
0:41 Add a gallery
1:27 AddColumns function
3:04 Sort by a choice column
4:37 Add a related column with lookup
6:45 Using AddColumns with a Collection
9:05 Add a Dynamic Date
10:44 ShowColumns function
13:21 DropColumns function
14:32 RenameColumns function
15:26 Use case ideas and the old syntax
17:13 Get a list of months
Do you need some help with something that you are working on, contact us!
powerapps911.com/contact
PowerApps911
powerapps911.com
Let's connect on social!
Twitter: twitter.com/ShanesCows
Facebook: facebook.com/powerapps911
Instagram: instagram.com/shaneyoung911
LinkedIn: linkedin.com/in/cincyshane
Join this channel to get access to perks:
youtube.com/channel/UC7_OGRP8BYvtGB8eZdPG6Ng/join
#powerapps #PowerPlatform #CanvasApps
