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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter by option field...
Power Apps
Answered

Filter by option field in dataverse using multiselect dropdown does not work

(0) ShareShare
ReportReport
Posted on by 38
 

Hi there! I have a Powerapps application connected to a dataverse table. The table has two option fields, "cr270_tipo", with the option "TIPODEAGENDA" and "cr270_estado", with the option "ESTADOAGENDA". I want to search for records in a gallery using 2 drop-down lists, "ddtipoagenda" and "ddestadoagenda" and two search fields, "txtclienteagenda" and "txtbuscaragenda". I have written the following formula:

If(
!IsBlank(txtclienteagenda) && !IsBlank(txtbuscaragenda) && !IsBlank(ddtipoagenda) && !IsBlank(ddestadoagenda);
Search(
Filter(
AGENDA_1;
NIF = txtclienteagenda.Text;
cr270_tipo = ddtipoagenda.Selected.Value;
cr270_estado = ddestadoagenda.Selected.Value
);
txtbuscaragenda.Text;
"cr270_notas";
"cr270_siniestro";
"cr270_poliza";
"cr270_recibo"
))
 
but it gives me an error in the rows:
cr270_type = ddtypeagenda.Selected.Value;
cr270_estado = ddestadoagenda.Selected.Value
 
What am I doing wrong?
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    on at

    Hi @Rfraile ,

     

    I tested it for you and did not encounter your problem.

    Please provide more details.

     

    1. What's formula of your 2 dropdown controls?
    2. What is the error message?
    3. If you use the following formula, will it work?
    Filter(
    AGENDA_1;
    cr270_tipo = ddtipoagenda.Selected.Value;
    cr270_estado = ddestadoagenda.Selected.Value
    )

    Or

    Filter(
    AGENDA_1;
    cr270_tipo = ddtipoagenda.Selected.Value
    )

     

    Best Regards,
    Wearsky
    If my post helps, then please consider Accept it as the solution to help others. Thanks.

     

  • Rfraile Profile Picture
    38 on at

    It works perfectly! Thank you!

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard