cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Power APPS filter Galery compare combo box items with collection table

 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.

 

 

powerapps1.pngpowerapps2.png

 

 

 

 

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)

 

 

 

powerapps3.png

 

 

 

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.

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,394)