Filter gallery

(0) Share

Report

Posted on by Alice23

102

Hello!

The checkbox is in a gallery that collects it's data from a collection:

I make this dropdown, how can I make to see:

- all the solved data when selected "Solved"
- all the unsolved data when selected "Unsolved"
-all data when nothing is selected ?

If(Dropdown4_2.Selected.Value="Solved",

Filter(? ,Checkbox3_6.Value=true),

If(Dropdown4_2.Selected.Value="UnSolved",

Filter(? ,Checkbox3_6.Value=false),

If(Dropdown4_2.Selected.Value=Blank(),

?)))

This is my code. With what can I replace the '?' in the code ?

I can't replace it with the name of collection, because column Status is the only one that didn't collect data from a collection.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Alice23 ,

Could you tell me:

If the status column is not in your collection, where does your status value come from?

Is the items property of your gallery a collection name?

Can you provide more information about the status column (check box)?

Best Regards,

Wearsky
Alice23 102 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-xiaochen-msft I just added a check box with code:
If(Checkbox3_6.Value,"Solved","Unsolved")
in my gallery:
And this is the code of what I wrote in Items in Gallery:
With( { wList: If( IsBlank(TextInput_lista_4.Text), Sort( Cerere, Titlul || Data_crearii_cererii || Adresa || Destinatar || Numarul_de_mijloace_de_transport_solicitate, Ascending ), Search( Cerere, TextInput_lista_4.Text, ("Titlul"), ("Adresa"), ("Destinatar"), ("Numarul_de_mijloace_de_transport_solicitate") ) )}, ForAll( Sequence(CountRows(wList)), Patch( Last( FirstN( wList, Value ) ), {RowNo: Value} ) ))