Unanswered

The formula contains an error

(0) Share

Report

Posted on by danielanjos100

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
)

Categories:

Error handling

All responses (3)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey

can u try this version:

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 )

if it helped please mark as verified answer

cheers
danielanjos100 8 on at

Like
a
(0)

Report
Copy link

Link copied!

"A fórmula abaixo ainda não está filtrando os itens: Forum.Value = Dropdown_forum. Selected.Value"
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

which error are u recieving?