Answered

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

(0) Share

Report

Posted on by Rfraile

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Rfraile ,

I tested it for you and did not encounter your problem.
Please provide more details.

What's formula of your 2 dropdown controls?
What is the error message?
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.

Was this reply helpful? Yes No
Rfraile 38 on at

Like (0)

Report
Copy link

Link copied!

It works perfectly! Thank you!

Was this reply helpful? Yes No