Hi Everyone,
I'm struggling Now for 2 days with something i thought would be not this complicated
I have a collection collected from Sharepoint at app OnStart, in wich i have a data table like this.
I have Build a Combobox populate with ALL Distinct Values in all my program table of my collection.
I want to build a gallery where i can filter my collection.
My issues is that i can't achieve a Filter from table element to table element, like if length of Join >0
What i have done so far
On select in my combo box, i create a selected item collection
ClearCollect(SelectedProgram;Self.SelectedItems.Result)
On my Gallery ( and here comes the trouble) in cannot create the expression that fits
Filter(
collectionSP;
IsBlank(ComboBox1_1.SelectedItems.Result) ||
IsEmpty(ComboBox1_1.SelectedItems.Result) ||
Programs.Value in SelectedProgram
)
But it doesn't work. I want to cross compare my 2 data table "SelectedProgram" with my collectionSP.Program data table , and returning in my Gallery all element where there is even a single match between my 2 tables
i also try a ForAll in my SelectProgram collection.
I also try to create a new colum in my collection where i flatten in a single string the whole program collection but didn't find a way to filter properly.
Thanks for the Help.
User | Count |
---|---|
253 | |
101 | |
94 | |
47 | |
38 |