Unanswered

Seeking Assistance with Power Apps Gallery Filter and Search Issue

(0) Share

Report

Posted on by JDGC

Hello,

I am encountering an issue with my Power Apps application. I have a Gallery that I'm trying to filter and search simultaneously, but I'm facing challenges with the implementation.

Here is the problem I'm experiencing:

I have a Gallery called BrowseGallery1with the following function:

OnSelec: Filter([@'Gestor PQRs']; StartsWith('NO. DE RADICADO'; TextSearchBox1.Text)).

The cascading filters are already defined in the pop-up.

.... Currently, I'm using the following formula to apply all filtering and searching functionalities:

Set(
FilterA;
BrowseGallery1.Selected
);
Search(
Filter(
[@'Gestor PQRs'];
'ÁREA RESPONSABLE'.Value = ddAreaResponsable.Selected.Value;
ESTADO.Value = ddEstado.Selected.Value;
'TIPO DE SOLICITUD'.Value = ddTipoSolicitud.Selected.Value
);
"ÁREA RESPONSABLE";
"ESTADO";
"TIPO SOLICITUD"
);
Set(
popUpFilter;
false
)

However, I'm not getting the desired results, (The button has an error.). Specifically, I want the user to be able to select filters and then press a button to apply all filters and search criteria simultaneously.

Can anyone please review the provided formula and offer guidance on how to achieve this functionality correctly? Any help would be greatly appreciated.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JDGC ,

You are missing the Search box

Set( FilterA; BrowseGallery1.Selected ); Search( Filter( [@'Gestor PQRs']; 'ÁREA RESPONSABLE'.Value = ddAreaResponsable.Selected.Value; ESTADO.Value = ddEstado.Selected.Value; 'TIPO DE SOLICITUD'.Value = ddTipoSolicitud.Selected.Value ); TextSearchBox1.Text; "ÁREA RESPONSABLE"; "ESTADO"; "TIPO SOLICITUD" ); Set( popUpFilter; false )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
JDGC 7 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz ;

Attached image, the pop-up where the filters to be used are independent of the search box. It is required to activate the 'Accept' button to apply the filters.

Set( FilterA; BrowseGallery1.Selected ); //Here is a error found (characters are used in the formula unexpectedly)character ";" Search( Filter( [@'Gestor PQRs']; 'ÁREA RESPONSABLE'.Value = ddAreaResponsable.Selected.Value; ESTADO.Value = ddEstado.Selected.Value; 'TIPO DE SOLICITUD'.Value = ddTipoSolicitud.Selected.Value ); TextSearchBox1.Text; "ÁREA RESPONSABLE"; "ESTADO"; "TIPO SOLICITUD" ); Set( popUpFilter; false )

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JDGC ,

Just so I am clear here, are you saying that

Set(
FilterA;
BrowseGallery1.Selected
);

Produces an error. I assume you are using European systwc ?

Was this reply helpful? Yes No