I have the following formula in the Item of the form:
LookUp(
CLSHoshin2023Initatives,
ID = OverallHorizentalGallery.Selected.ProgramsPerCategoryGallery.Selected.ID
)
CLSHoshin2023Initatives is my data source.
OverallHorizentalGallery is my outer gallery.
ProgramsPerCategoryGallery is the vertical gallery where I select an item from there.
The Items in my OveralHorizentalGalley are: (which works fine)
Table({ColName: "1. Customer centricity"},{ColName: "2. Differentiated offers"},{ColName: "3. Growth for sustainability"},{ColName: "4. Digitalization"},{ColName: "5. Great place to work"},{ColName: "6. Growth Projects"})
The Items in my inner Vertical Galley are: (Which works fine)
SortByColumns(AddColumns(Filter(
CLSHoshin2023Initatives,
FiveFrontierStrategy.Value = ThisItem.ColName
),"MyLeader",Concat(Leader.DisplayName,DisplayName)),"MyLeader",Ascending)
Please let me know how I can correct my formula for the Item in the form.