cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Filter by displayname

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/objectifsObjectifs 1Objectifs2Objectifs 3
Outils 1YESYESNO
Outils 2NOYESNO
Outils 3NOYESYES

 

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 

2 REPLIES 2
Highlighted
Super User
Super User

Re: Filter by displayname

@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."

Highlighted
Regular Visitor

Re: Filter by displayname

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

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,630)