Hi @norashura,
Your Filter condition is currently not linked to a field within your datasource. You will have to add which column the selected 'Project Name' maps to in your data source:
SortByColumns(
Filter(
[@'***** Lesson Learn'],
//Currently linked it to the project name field, adjust to the correct column if needed
IsBlank(ComboBox.Selected.'Project Name') || ComboBox.Selected.'Project Name' = 'Project Name'
),
"Title",
If(
SortDescending1,
SortOrder.Descending,
SortOrder.Ascending
)
)
Since you are already displaying a few columns you could work with dynamic visibility, X and Y values and only display certain header labels / gallery labels when a checkbox is checked. Example Project Name:
//Visible property (same logic for the gallery project name label)
ckbProjectName.Value = true
Alternatively you could create a dropdown with the following values as an example:
["Project Name", "Title"]
Instead of having several header labels, you would have 1 that displays text depending on the selection:
//Text property Header label
ColumnDropdown.Selected.Value
The Text property of the label within your gallery would be:
Switch(
ColumnDropdown.Selected.Value,
"Project Name",
ThisItem.'Project Name',
"Title",
ThisItem.Title
)
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
