No display of the entire database in Gallery

[Digitalartnet]

Hello 

I have there times 2 questions:

1.
I have a filter (Code)

Filter(

Tbl_Datenbank;

Bezeichnung = CB_Bezeichnung.Selected.Result

And

Länge >= Value(Lbl_Länge_min.Text) && Länge <= Value(Lbl_Länge_max.Text)

And

Breite >= Value(Lbl_Breite_min.Text) && Breite <= Value(Lbl_Breite_max.Text)

And

Höhe >= Value(Lbl_Höhe_Min_1.Text) && Höhe <= Value(Lbl_Höhe_max_1.Text)

)

Unfortunately, no database entries are displayed to me at the beginning.

2.
The Reset Button ( Code )

Reset(CB_Bezeichnung);;Reset(Länge);;Reset(Breite);;Reset(Höhe)

Deletes all entries in the textboxes and comboboxes.

The database is not displayed in the gallery.

I am a newbie in Powerapps and I don't know what to do...

Do you have an idea how I can correct this?

Greetings

DAN

[Nogueira1306]

Filter(

Tbl_Datenbank;

Bezeichnung = CB_Bezeichnung.Selected.Result;

Länge >= Value(Lbl_Länge_min.Text);

Länge <= Value(Lbl_Länge_max.Text);

Breite >= Value(Lbl_Breite_min.Text);

Breite <= Value(Lbl_Breite_max.Text);

Höhe >= Value(Lbl_Höhe_Min_1.Text);

Höhe <= Value(Lbl_Höhe_max_1.Text)

)

Using that you are assuming that everything has values and nothing is blank.
You should check if things are empty or not.

I can show you one of my filters with that. In this case I have the Client, Product, Begin date and End date

I did this almost a year ago, I did not know as much as I know now.

varFiltro is on property OnSelect of the combobox:

Set(varFiltro; ComboBox2.Selected.Value)

If( varFiltro = "" && IsBlank(DatePicker1) = true && IsBlank(DatePicker1_1) = true;
        Sort(Saída;Data;Descending);
    If(varFiltro = "" && IsBlank(DatePicker1) = false && IsBlank(DatePicker1_1) = true;
        Sort(Filter(Saída;Data >= DatePicker1.SelectedDate);Data;Descending);
        If(varFiltro = "" && IsBlank(DatePicker1) = false && IsBlank(DatePicker1_1) = false;
            Sort(Filter(Saída;Data >= DatePicker1.SelectedDate;Data <= DatePicker1_1.SelectedDate);Data;Descending);
            If(varFiltro = "" && IsBlank(DatePicker1) = true && IsBlank(DatePicker1_1) = false;
                Sort(Filter(Saída;Data <= DatePicker1_1.SelectedDate);Data;Descending);

                If(IsBlank(DatePicker1) = true && IsBlank(DatePicker1_1) = true && varFiltro2 = "";
                    Sort(Filter(Saída; Cliente.Value = varFiltro);Data;Descending);
                    If(IsBlank(DatePicker1) = false && IsBlank(DatePicker1_1) = true && varFiltro2 = "";
                        Sort(Filter(Saída; Cliente.Value = varFiltro; Data >= DatePicker1.SelectedDate);Data;Descending);
                        If(IsBlank(DatePicker1) = true && IsBlank(DatePicker1_1) = false && varFiltro2 = "";
                            Sort(Filter(Saída; Cliente.Value = varFiltro; Data <= DatePicker1_1.SelectedDate);Data;Descending);
                            If(IsBlank(DatePicker1) = true && IsBlank(DatePicker1_1) = true && varFiltro2 = "";
                                Sort(Filter(Saída; Cliente.Value = varFiltro; Data >= DatePicker1.SelectedDate; Data <= DatePicker1_1.SelectedDate);Data;Descending);

                                If(IsBlank(DatePicker1) = true && IsBlank(DatePicker1_1) = true;
                                    Sort(Filter(Saída; Cliente.Value = varFiltro; Produto.Value = varFiltro2);Data;Descending);
                                    If(IsBlank(DatePicker1) = false && IsBlank(DatePicker1_1) = true;
                                        Sort(Filter(Saída; Cliente.Value = varFiltro; Data >= DatePicker1.SelectedDate; Produto.Value = varFiltro2);Data;Descending);
                                        If(IsBlank(DatePicker1) = true && IsBlank(DatePicker1_1) = false;
                                            Sort(Filter(Saída; Cliente.Value = varFiltro; Data <= DatePicker1_1.SelectedDate; Produto.Value = varFiltro2);Data;Descending);
                                            Sort(Filter(Saída; Cliente.Value = varFiltro; Data >= DatePicker1.SelectedDate; Data <= DatePicker1_1.SelectedDate; Produto.Value = varFiltro2);Data;Descending)
                                        )
                                    )
                                )
                            )
                        )
                    )
                )
            )
        )
    )
)

For the second one. Reset should only be in textinputs and stuff like that.

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

[Digitalartnet]

Wow
Thanks first of all for your time.

I can't get to grips with the code at all.
It's all too much...

Can you maybe relate this to what I have as code?

Sorry I am really a beginner in PowerApps!

Greetings
Dan

[Nogueira1306 · Accepted solution]

varFiltro = Bezeichnung 

DatePicker1 = Lange

DatePicker1_1 = Breite

varFiltro2 = Hohe

In filter you just use yours with the new "vars"

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!