cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User III
Super User III

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

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (71,490)