Hi everyone,
Can you help me fix the error in the formula below? I think it’s not configured correctly. After I enter the page and select "Dropdown_forum.Selected.Value", it stays blank and doesn’t filter the desired items.
I believe the problem is related to the beginning of the formula:
But I don’t know how to restructure the code.
Formula I currently use
SortByColumns(
Filter(
'Repositório de apresentações';
IsBlank(Gallery_home.Selected.Nome) || Forum.Value = Gallery_home.Selected.Nome;
IsBlank(Dropdown_forum.Selected.Value) || Forum.Value = Dropdown_forum.Selected.Value;
Ano.Value = Dropdown_ano.Selected.Value
);
"Data";
SortOrder.Descending
)