I have a parent/child gallery in my PowerApps and I have in the child gallery Agenda items.
I would like to show in my agenda the two people who are presenting the Team Activity.
Filter(
ForAll(
SortByColumns(
Filter(
'All Hands Meeting Pages',
MasterID = ThisItem.ID
),
"PageOrder",
SortOrder.Ascending
) As p,
{
ColumnName: p.PageName,
ColumnValue: Switch(
p.PageName,
"Cover Sheet", "Cover Sheet",
"Agenda", "Agenda",
"Opening Remarks", ThisItem.'Presenter Opening Remarks'.DisplayName,
"Remarks", ThisItem.'Presenter BZ_Remarks'.DisplayName,
"Hails", ThisItem.'Presenter Hails_Farewells'.DisplayName,
"Farewells", ThisItem.'Presenter Hails_Farewells'.DisplayName,
"Team Activity", Concat(ThisItem.'Presenter1 Team Activity', DisplayName, " & "),
ThisItem.'Backup Page 1 Title', ThisItem.'Backup Page 1 Presenter'.DisplayName,
ThisItem.'Backup Page 2 Title', ThisItem.'Backup Page 2 Presenter'.DisplayName,
ThisItem.'Backup Page 3 Title', ThisItem.'Backup Page 3 Presenter'.DisplayName,
ThisItem.'Backup Page 4 Title', ThisItem.'Backup Page 4 Presenter',
"Presenter Other", ThisItem.'Presenter Other'.DisplayName,
"Remarks-Front Office", "Remarks-Front Office",
"Remarks-IT Ops", "Remarks-IT Ops",
"Remarks-Digital Innovation & Data", "Remarks-Digital Innovation & Data",
"Remarks-IT PfM", "Remarks-IT PfM",
"Remarks-CISO", "Remarks-CISO",
"Remarks-Other Support Function", "Remarks-Other Support Function",
"Employee Spotlight", "Employee Spotlight",
"Personal Information", "Personal Information",
"Education and Experience", "Education and Experience",
"Family and Fun", "Family and Fun",
""
),
PageOrder: p.PageOrder
}
),
Not(IsBlank(ColumnValue))
)
However the code I am using while it should work is not working
"Team Activity", Concat(ThisItem.'Presenter1 Team Activity', DisplayName, " & ") which is why I am here. I show both people in my SharePoint list but it only displaying one person in the gallery.