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!
https://www.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!
https://www.powerapps911.com/contact
PowerApps911
https://www.powerapps911.com/
Let's connect on social!
Twitter: https://twitter.com/ShanesCows
Facebook: https://www.facebook.com/powerapps911
Instagram: https://www.instagram.com/shaneyoung911/
LinkedIn: https://www.linkedin.com/in/cincyshane/
Join this channel to get access to perks:
https://www.youtube.com/channel/UC7_OGRP8BYvtGB8eZdPG6Ng/join
#powerapps #PowerPlatform #CanvasApps