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
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
User | Count |
---|---|
207 | |
100 | |
91 | |
46 | |
43 |
User | Count |
---|---|
251 | |
105 | |
104 | |
65 | |
57 |