Hi @MSDigitalUser ,
Same principle except you're going to merge a Filter condition into the expression. Apply the below to the Items property of your Gallery.
Sort(
Filter(
AddColumns(
'Your Data',
"Quarters",
"Q" & RoundUp(
Month('Your Date Column') / 3,
0
)
),
Quarters = Your_drop_down_control.Selected.Value
),
Quarters,
SortOrder.Ascending
)
Please note if you have a Form control associated to your Gallery, the above expression will break the Form control and you will receive an "Invalid formula. Expected a value compatible with 'DataSource' error . To fix this you will need to change the Items property of the Form to:
LookUp(
'Your Data',
ID = VarRecord.ID //whatever your actual variable name is
)
Or:
LookUp(
'Your Data',
ID = Your_Gallery.Selected.ID
)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
