Unanswered

Filter a Gallery With a Many Inputs

(0) Share

Report

Posted on by ewpreis

Hi,

I need help, how can I filter my gallery with radio buttons? I tried diferent many ways , but I can't make it. In my gallery there are seven filters, see filters below:

Column Name = User().Fullname

Column Date >= varDateBegin && varDateEnd >= Date

Column Order = TexteInput1_1

Column Line = Radio1_4

Column Machine = Radio1_5

Column Event = Radio1_6

Column Equipment = Radio1_7

I can do it filter with these code

If(Toggle1_1.Value = true;Filter('Relatório Turno'; Nome = User().FullName;DataExtenso >= varDataInicio && varDataFim >= DataExtenso))

But I can't do it filter when I insert the radios buttons and TextInput1_1

How can I filter with all this items? can someone help?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ewpreis :
Could you tell me what these field's data types are ?
Order
Line
Machine
Event
Equipment
I assume they meet the following conditions(If these fields are other data types, please tell me what data types they are and what is your data source)
Filed Name Data Type
Order Text
Line
Boolean
Machine Boolean
Event Boolean
Equipment Boolean
Please try:

If(Toggle1_1.Value = true; Filter('Relatório Turno'; Nome = User().FullName && DataExtenso >= varDataInicio && varDataFim >= DataExtenso && Order=TexteInput1_1.Text && Line=Radio1_4.Value && Machine=Radio1_5.Value && Event = Radio1_6.Value && Equipment = Radio1_7.Value ) )

If you still have any problem ,please feel free to let me know.
Best Regards,
Bof

Was this reply helpful? Yes No
ewpreis 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft, thank you for your help!

My field's data types these:

Order = text
Line = text
Machine = text
Event = text
Equipment = text

The field's Line, Machine, Event and Equipment I use dropdow for choice your value and save information in my data base in sharepoint

I tested your code, but it gave error

Thank you,

Best Regards!

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ewpreis :
I get it.
First,let me explain why you encounted this problem.
The point is "Inconsistent data types".
The value of Radio1_4.Value is Boolean
The value of Line is Text
Secondly,please try:

If(Toggle1_1.Value = true; Filter('Relatório Turno'; Nome = User().FullName && DataExtenso >= varDataInicio && varDataFim >= DataExtenso && Order=TexteInput1_1.Text && Line=If(Radio1_4.Value,"True","False") && Machine=If(Radio1_5.Value,"True","False") && Event = If(Radio1_6.Value,"True","False") && Equipment = If(Radio1_7.Value,"True","False") ) )

Best Regards,
Bof

Was this reply helpful? Yes No
ewpreis 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

I get it, but I think this problem was cause because Radio1_4.Value don't exist. I tested your new code, but the problem to be continued.
When I digit Radio1_4. show me many option, but Value don't show. Only when I digit Radio1_4.Selected.

In my radio buttons there are these fields:

Radio1_4: ["-";"72";"74";"75";"76";"91";"92";"93";"#F7";"#F9";"LAB";"DECORAÇÃO"]
Radio1_5:["1";"2";"3";"4";"5"]
Radio1_6:["CORRETIVA";"PREVENTIVA";"MANUSEIO";"MELHORIA";"PROGRAMADA";"PENDÊNCIA"]
Radio1_7:["FP";"FPX2";"MCALL";"ART";"ICK";"VIDEOJET";"REDE";"IDA";"RPT2";"HECM-S";"FCM-S";"SERVIDOR";"EASIER"]

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ewpreis :
Sorry, the code I provided earlier has some mistakes.
Please try this code:

If(Toggle1_1.Value = true; Filter('Relatório Turno'; Nome = User().FullName && DataExtenso >= varDataInicio && varDataFim >= DataExtenso && Order=TexteInput1_1.Text && Line=Radio1_4.Selected.Value && Machine=Radio1_5.Selected.Value && Event = Radio1_6.Selected.Value && Equipment = Radio1_7.Selected.Value ) )

Best Regards,
Bof

Was this reply helpful? Yes No
ewpreis 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @v-bofeng-msft

I tried your code, the gallery stay blank and when I change radio button, change date or digit the order number don't make anything

An alert appears in the gallery: delegation notice. The filter part of this formula may not work correctly on large data sets.

Was this reply helpful? Yes No
CU24091509-0 417 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please post few screenshots?

Was this reply helpful? Yes No
ewpreis 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @KranthiTupakula Sure!

You want a specific screenshots?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ewpreis :

First,let me explain why you encounted a "delegation warning".

The point is "<, <=,<>, >, >= is not delegable for DateTime field in sharepoint".

Secondly,In order to reduce the impact of delegation issues, I suggest you:

solution1:adjust the value of Data row limit for non-delegable queries to 2000.

file-Settings-Advanced settings

solution2:If the number of records is greater than 2000.The data source can be segmented and saved in batches to a collection.(The data source must be delegateable)

I assume YourDateSouce is a SharePoint list and "Kind" is one of the text type fields

For example:

Set the app's OnStart proeprty to:

Clear(MyCustomCollection) Collect(MyCustomCollection,Filter(YourDateSouce,Kind="Kind1")); Collect(MyCustomCollection,Filter(YourDateSouce,Kind="Kind2")); ……

Best Regards,

Bof

Was this reply helpful? Yes No
ewpreis 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Ok, I understood your explanation. But I have a question, in this moment my data source has thirteen itens because I am testing and developing yet, but in the future there will be more than two thousand items. In only one gallery can I have more than one collection?

Was this reply helpful? Yes No