I have a master gallery (let's call it gallery 1) that shows all items. This gallery has a handful of dropdowns and combo boxes to help filter what a user might be looking for. There are also 3 other galleries that show the makeup of gallery 1.
- gallery 2: records with missing titles
- gallery 3: records with invalid titles
- gallery 4: records with duplicate titles
gallery 4 is where I am running into the issue. I can't seem to populate it. I've unsuccessful tried the CountIf() function and the closest I got was GroupBy, but then all the other data is lost in that gallery (unless I declare all of those fields). I'm also using the Gallery1Name.AlItems for each source.
database is a SharePoint list and using collections to populate them since they are large
Items:
Gallery_1:
Filter(colGallery1,
Item1 = dropdown1.selected.value || dropdown1.selected.value = blank()),
Item2 = dropdown2.selected.value || dropdown2.selected.value = blank()),
Item3 = dropdown2.selected.value || dropdown2.selected.value = blank()))
Gallery_2:
Filter(Gallery_1.AllItems,
IsBlank(Title))
Gallery_3:
Filter(Gallery_1AllItems,
Not(Title in ShowColumns(colTitleList, 'Task Titles'))