If statement with Multiple conditions not working

[Anonymous]

Hi all,

I have a form (see first image below) with three choices (Overview, Strategies, Recommended Participants). I want the DefaultSelectedItems in the combobox to pre-fill based on whether other fields in the form are selected so I'm using the Not(IsBlank() formula. I've tested each of the formulas individually and they work fine (the appropriate value gets pre-filled), however, when 2 or more values are selected are the first value is selected - in this case it's always Overview.

How do I make it so that if 2 values are selected, 2 are pre-filled, or 3 are selected and 3 are prefilled.

Thanks!

[RandyHayes · Accepted solution]

@Anonymous 

Please consider changing your DefaultSelectedItems property Formula to the following:

Filter(
    [If(!IsBlank(DatCardValue10.Text), "Overview"),
     If(!IsBlank(DataCardValue8.Selected.Value), "Strategies"),
     If(!IsBlank(DataCardValue7.Selected.Value), "Recommended Participants")
    ],
    !IsBlank(Value)
)

In your original formula you were performing a !IsBlank function on a table.  SelectedItems is a table of records.  So if you are trying to determine if something is or is not selected, then performing the !IsBlank function on the single record (.Selected) is all you need.

I hope this is helpful for you.

[Anonymous]

Brilliant! That worked perfectly! Thanks so much @RandyHayes 

When I tried to add the multiple If statements it didn't originally work for me, is it the [] brackets that makes the difference?

Thanks again

[RandyHayes]

@Anonymous 

Well, the square brackets just denote a table.  When you use them, PowerApps will generate a table with a Value column.

The formula is equivalent to the following:

Filter(
    Table(
        {Value: If(!IsBlank(DatCardValue10.Text), "Overview")},
        {Value: If(!IsBlank(DataCardValue8.Selected.Value), "Strategies")},
        {Value: If(!IsBlank(DataCardValue7.Selected.Value), "Recommended Participants")}
    ),
    !IsBlank(Value)
)

So the answer is yes and no.  Yes, you needed to provide a table to the DefaultSelectedItems property in order to have multiple selections.  In your formula, you were only ever going to provide one record - so only one item would have ever been selected.

But, No, just putting what you had in square brackets would not have resolved anything.  The records within the table would have needed to be specified properly.  And then you would always want to filter out the blank records, or it will screw up the selections.

[Anonymous]

Thank you for explaining it to me, it makes sense - now I know what to do for next time!