Filter not working

(0) Share

Report

Posted on by TS5

Hi Guys,

i'm quite a newbie to Power Apps, therefore im making some dumb mistakes.

It would be awesome, if you could guide me the way to success. In this particular case, I've got a problem with filters, the Datasource is a Share Point list.

Somehow it does not work...

You can find the ScreenShots attached.

Torben

Bildschirmfoto 2021-09-25 um 12.38.17.png

Bildschirmfoto 2021-09-25 um 12.38.50.png

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you tell us more about how you want your filter to function? Your filter appears to be attempting to show empty or blank records, plus an unusual condition of:
which is likely to generate an error. "Status" is a string, and ComboBox1.SelectedItems is a table. Instead, are you instead looking to filter results using a column called Status?

Bryan

Was this reply helpful? Yes No
TS5 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bryan,

Indeed, I'm trying to combine two filters, "RTV-Vorgang" which is a String. And then the ComboBox. "Status" is a Column in a Sharepoint list.

Is there a possibility to solve this problem?
Torben

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
OK, try this:
Search( Filter( Fehlerprotokoll; Status in ComboBox1.SelectedItems.Value ); TextInput1.Text; "RTV_x002d_Nummer" )
Depending on the type of column for Status, you may need to reference Status.Value instead of simply Status in this code. In addition, if your combobox's Items property was populated using the Distinct function, you may need to put in .Result instead of .Value.

Hope that helps,
Bryan

Was this reply helpful? Yes No
TS5 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Cheers Bryan, it does work 😄

- but if nothing is selected in the ComboBox and something in the TextBox is written, there are no results shown. As well if both are empty, im not able to see any gallery entries.

BR
TOrben

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TS5 ,

Not tested but you can try the below code if it helps in your requirement.

if(!IsBlank(TextInput1.Text),Search( if( !IsBlank(ComboBox1.SelectedItems.Value),Filter( Fehlerprotokoll; Status in ComboBox1.SelectedItems.Value ),Fehlerprotokoll); TextInput1.Text; "RTV_x002d_Nummer" ), if( !IsBlank(ComboBox1.SelectedItems.Value),Filter( Fehlerprotokoll; Status in ComboBox1.SelectedItems.Value ),Fehlerprotokoll))

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.

Was this reply helpful? Yes No
TS5 12 on at

Like
a
(0)

Report
Copy link

Link copied!

it does not work 😕
but i can not tell you why? - maybe there are some brakets missing?

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TS5 ,

What is the error message your getting ?

Was this reply helpful? Yes No
TS5 12 on at

Like
a
(0)

Report
Copy link

Link copied!

execution of a unknowen or undefined function

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Is below code working for you ?
Search( if( !IsBlank(ComboBox1.SelectedItems.Value),Filter( Fehlerprotokoll; Status in ComboBox1.SelectedItems.Value ),Fehlerprotokoll); TextInput1.Text; "RTV_x002d_Nummer" )

Was this reply helpful? Yes No
TS5 12 on at

Like
a
(0)

Report
Copy link

Link copied!

there is the same mistake... 😕 execution of a unknowen or undefined function

Was this reply helpful? Yes No