Using Ungroup for Flattening your Data Source in Power Apps (Data Manipulation)

Last week we made a video based on Flattening your dataset and we used ForAll, and after a realization maybe it's better to use Ungroup. Here is last weeks video: https://www.youtube.com/watch?v=244WMVLuZck

Ungroup may be a better alternative, but in my opinion learning both is the most important!

Discover a simple method to ungroup a multi-select field in SharePoint! In this tutorial, we break down the process of separating selected values from a SharePoint list, making it easier to organize and analyze your data. Whether you're new to SharePoint or looking to enhance your skills, this video offers a fresh approach to managing complex lists. Check it out and take your SharePoint knowledge to the next level!

Formula for ungroup:
ClearCollect(colFunGrouped,Ungroup(ShowColumns(colSharePoint,ID,Title,Manager,Details),Details))

Chapters:
0:00 Introduction
1:06 PowerFx Formula different based on region
2:30 Compare ForAll AddColumns DropColumns
3:40 The SharePoint list
5:06 What is a record?
6:05 Collecting the SharePoint list
7:49 The Actual Formula to Ungroup
9:31 The Ungrouped table
10:03 If comma delimited maybe ForAll

Видео Using Ungroup for Flattening your Data Source in Power Apps (Data Manipulation) канала Andrew Hess