IF statement - show SP List without not working

(0) Share

Report

Posted on by minimax80

Hi,

I have a simple If statement which shows a list either with or without Filter function.

If(IsEmpty(Dropdown1.Selected), 'Issue tracking', Filter('Issue tracking', Location in Dropdown1.SelectedText.Value))

It checks if something in a dropbox field is selected or not. If nothing is selected it should just show the SP List 'Issue tracking' without any filtering. (This part seems not to work) If something is selected it shows the SP List with a Filter function. (this is working!).

Does anyone has an idea what is wrong here....

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Add "All" in your Location list in the first entry. That way it will be default selected.
Write this in your item:
Filter('Issue tracking', Location.Value=Dropdown1.Selected.Value ||Dropdown1.Selected.Value ="All"))
Verified answer

minimax80 9 on at

Like
a
(0)

Report
Copy link

Link copied!
After 2 days of trying i just found the solution. My IsEmpty did not work the way i expected it and i replaced it by IsBlank
If(IsBlank(Dropdown1.SelectedText.Value), 'Issue tracking', Filter('Issue tracking', Location in Dropdown1.SelectedText.Value))