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
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

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

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,132)