Answered

If statement with multiple conditions

(0) Share

Report

Posted on by arinard

I'm trying to filter a gallery using one dropdown and one text input/search bar, and I'm having trouble getting both of them to work at the same time. I'm used to Excel where I can nest If statements easily, but I'm running into issues in PowerApps. What I have now is:

If(IsBlank(drpColor) && IsBlank(TextInput1), 'Shoe Inventory Finals', If(IsBlank(drpColor) && !IsBlank(TextInput1), Search('Shoe Inventory Finals', TextInput1.Text, "cr1ae_productname", If(!IsBlank(drpColor && IsBlank(TextInput1), Filter('Shoe Inventory Finals', Color = drpColor.Selected.Value, Search(Filter('Shoe Inventory Finals', Color = drpColor.Selected.Value), TextInput1.Text, "cr1ae_productname")

What I want it to do is check if both the dropdown and the input are blank, and return the whole table if true. If not true, check if only one is blank and filter appropriately. If none of these conditions are true, meaning both the dropdown and the text input are not blank, I want to filter the list based on both of them.

Thanks in advance!!

Categories:

Building Power Apps

All responses (15)

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@arinard - I think the below is what you're trying to do:

Search( Filter( 'Shoe Inventory Finals', Len(drpColor.Selected.Value) = 0 || Color = drpColor.Selected.Value ), TextInput1.Text, "cr1ae_productname" )

I can see from your code that your data source is Dataverse. The above assumes the Color field is a Single Line Text data type in your table.
arinard 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Amik, thanks for your response. My source is Dataverse, however the Color column is in choice format. Are there edits needed to make it work? I'm not familiar with the Len function.
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@arinard - the answer depends on what you have in the Items property of that Dropdown control
arinard 71 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik The Items property is Choices(ColorList). ColorList is a collection that is created in the OnVisible property of the screen from the choices available in the Color column of my data.
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@arinard - is there a reason you're creating a Collection of the Choices field values, rather than simply referring to the Choices field directly?
arinard 71 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik That's how I saw it done in a tutorial, but I can change it to just refer to the choices if that's the best way. It works when I change the Items field for the dropdown to Choices('Shoe Inventory Finals'.Color), with Shoe Inventory Final being my source table
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@arinard - whoever did that tutorial was wrong, or they were trying to do something else.

Is your Choice field Local or Global?, the syntax you provided is one that I recognise as valid for SharePoint, but not for Dataverse.

Choices('Shoe Inventory Finals'.Color)
arinard 71 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik My Choice field is Local
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@arinard - would you mind clicking on the Items property and sharing a screenshot of the formula bar. I am struggling to believe that this is valid syntax for a Dataverse Local Choice.
arinard 71 on at

Like
a
(1)

Report
Copy link

Link copied!

@Amik I very well may have just gotten lucky, I'm a total beginner with PowerFx.

Here is the formula bar with the dropdown in the body of the app seemingly pulling the choices:

I'd be happy to change the syntax if you know the correct syntax to use