Filter fail

Like (0) Share

Report

Posted on 17 Dec 2021 19:34:29 by 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.

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (8)

Answers (1)

AJ_Z 3,711 Super User 2024 Season 1 on 20 Dec 2021 at 11:06:40

Like (0)

Report

Re: Filter fail

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 🙂

Was this reply helpful? Yes No
JeffreyP 30 on 20 Dec 2021 at 10:43:10

Like (1)

Report

Re: Filter fail

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!

Was this reply helpful? Yes No
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on 20 Dec 2021 at 02:09:31

Like (1)

Report
Re: Filter fail

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 🙂

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on 20 Dec 2021 at 02:05:32

Like (1)

Report
Re: Filter fail

Just checking you did try it with the correct gallery name right?:
LookUp( SPLIST1, ID = GalleryWal1.Selected.ID )

Was this reply helpful? Yes No
JeffreyP 30 on 19 Dec 2021 at 23:35:33

Like (1)

Report

Re: Filter fail

Unfortenetly, still showing the last submitted one..
If i remove the filter, everything works well..
I dont know what is wrong in the filter

Was this reply helpful? Yes No
WarrenBelz 149,738 Most Valuable Professional on 18 Dec 2021 at 20:23:12

Like (1)

Report
Re: Filter fail

@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

Was this reply helpful? Yes No
JeffreyP 30 on 18 Dec 2021 at 10:07:00

Like (1)

Report

Re: Filter fail

GalleryWal1.Selected
Thats the Gallery where items is the above Filter

Was this reply helpful? Yes No
WarrenBelz 149,738 Most Valuable Professional on 17 Dec 2021 at 20:29:44

Like (1)

Report

Re: Filter fail

Hi @JeffreyP ,

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

Was this reply helpful? Yes No