Filter by displayname

[gaxuxa64]

Hello, and sorry for my english...

Problem n°1 : 

I need to selected in my gallery a list of Outils

One Outil can have many objectifs and one objectif can have many outils. 

This Table is Description outils

Outils/objectifs	Objectifs 1	Objectifs2	Objectifs 3
Outils 1	YES	YES	NO
Outils 2	NO	YES	NO
Outils 3	NO	YES	YES

Can i use the Filter function to say  : 

Filter(description_outils;DisplayName = "Yes");Outils ?  Of course it doesn't work. 

Problem n°2 : 

I need to select only the Objectifs selected in my previous page, with another table. 

I try this : 

Sort(Filter(description_outils;DisplayName = objectifs_gallerie.Selected.Text);Outils;Ascending)

But it doesn't work.... 

Thank you so much for help me 

[mdevaney]

@gaxuxa64 

Best to solve issues one at a time.

#1  Your text does not match your table's UPPERCASE exactly.

Filter(description_outils;DisplayName = "YES")

If this is a Yes/No in SharePoint it actually becomes true/false in PowerApps

Filter(description_outils;DisplayName = true)

#2  You need to reference a specific column name.  

Sort(
  Filter(
    description_outils;
    DisplayName = objectifs_gallerie.Selected.your_column_name
  );
  Outils;
  Ascending
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[gaxuxa64]

Hello and thank you so much,

#1 

I test this way : 

Filter(description_outils;DisplayName = true)

But it doesn't work. 

 I work with excel and not Sharepoint. The file it's in attachments. 

#2 

If i have a lot of columns, i need to write this ?  

Sort(
  Filter(
    description_outils;
    DisplayName = objectifs_gallerie.Selected.your_column_name1 and your_column_name2 and your_column_name3...
  );
  Outils;
  Ascending
)

Thank you again