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

I have the same question (0)

All responses (3)

Answers (0)

mmbr1606 14,560 Super User 2025 Season 2 on at

Like (0)

Report
The formula contains an error

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

Was this reply helpful? Yes No
danielanjos100 8 on at

Like (0)

Report

The formula contains an error

"A fórmula abaixo ainda não está filtrando os itens: Forum.Value = Dropdown_forum. Selected.Value"

Was this reply helpful? Yes No
mmbr1606 14,560 Super User 2025 Season 2 on at

Like (0)

Report

The formula contains an error

which error are u recieving?

Was this reply helpful? Yes No