web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Error Handling
Unanswered

The formula contains an error

(0) ShareShare
ReportReport
Posted on by 8

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:

 
less
Filter(
'Repositório de apresentações',
IsBlank(Gallery_home.Selected.Nome) || Forum.Value = Gallery_home.Selected.Nome
)

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
)
I have the same question (0)
  • mmbr1606 Profile Picture
    14,353 Super User 2025 Season 2 on at
    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
  • danielanjos100 Profile Picture
    8 on at
    The formula contains an error

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

  • mmbr1606 Profile Picture
    14,353 Super User 2025 Season 2 on at
    The formula contains an error
    which error are u recieving?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 714 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard

Featured topics