Filter fail

[JeffreyP]

Hi guys,

I used a couple of youtube movies to filter my gallery. I tought everyting was working but, it if i click on a item in my gallery. It always opens the newest one instead of the one i clicked. if i remove my filters on the gallery it works well..

I hope someone can help me with this.

SortByColumns(
    Filter(
        SPLIST1;
        StartsWith(
            Datum;
            TextSearchBox12_1.Text
        ) && IsBlank(ComboBox2.SelectedItems.Value) || IsEmpty(ComboBox2.SelectedItems) || Discipline in ComboBox2.SelectedItems;
        Datum >= dpFrom.SelectedDate && Datum <= dpTo.SelectedDate;
        If(
            ShowEigen.Value = true;
            Melder = User().FullName;
            ShowEigen.Value = false
        )
    );
    "Datum";
    Descending;
        "ID";
    Descending
)

It works with my Sharepoint list: SPLIST1

I have a search textbox that search on the column Datum (date).

Then i filter on a multiple selectbox (dropdown menu multiple selected)

And i filter with 2 date pickers.

The last one is a checkbox, if checked (by default) it only shows your own items (on the 365 office name).

The Filters are working but only opens the newest item unfortenetly.

[WarrenBelz]

Hi @JeffreyP ,

What is the Item of the Form that is being opened ?

[JeffreyP]

GalleryWal1.Selected

Thats the Gallery where items is the above Filter

[WarrenBelz]

@JeffreyP ,

Try

LookUp(
   SPLIST1,
   ID = Gallery1.Selected.ID
)

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.

Visit my blog Practical Power Apps

[JeffreyP]

Unfortenetly, still showing the last submitted one..

If i remove the filter, everything works well..

I dont know what is wrong in the filter

[AJ_Z]

Just checking you did try it with the correct gallery name right?:

LookUp(
   SPLIST1,
   ID = GalleryWal1.Selected.ID
)

[AJ_Z · Accepted solution]

Also does anything refresh or reset the gallery's .selected value. one way to see this is change the onselect for this gallery to Set(VarGallWal1Selected,ThisItem) and make the lookup:

LookUp(
   SPLIST1,
   ID = VarGallWal1Selected.ID
)

also please don't forget to adjust commas to semi colons for your local language settings 🙂

[JeffreyP]

Yes i changed the name correctly 🙂

The OnSelect on the Gallery is now:

Set(VarGallWal1Selected;ThisItem);;
Navigate(ReadWal1; ScreenTransition.None)

Item in the Form is set to VarGallWal1Selected

This works fine for me 🙂 thankyou!

[AJ_Z]

Excellent i am happy my suggestion was able to help 🙂 . Please could you click accept it as the solution to help others who are looking for solutions to similar problems 🙂