Answered

Visible Formula Not Working

(1) Share

Report

Posted on by Poweruser811

Hi,

I have a drop down menu with 5 different options. I also have a 3 different sub options fields to be displayed depending the value selected.

For the 3 different sub options, I used these formulas below. The user can select multiple values from the drop down menu and I want to show the sub options based on the value selected. Theoretically all 3 sub options should show up if the specific list items are selected. The issue I am running into is that only one sub option is showing up even though I selected all the different options.

If(DataCardValue4.Selected.Value = "Apple", true, false)

If(DataCardValue4.Selected.Value = "Orange", true, false)

If(DataCardValue4.Selected.Value = "Cherry", true, false)

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

LaurensM 12,512 Moderator on at

Like (2)

Report
Re: Visible Formula Not Working

Hi @Poweruser811,

.Selected.Value will only return the last selection (in the context of multi-select comboboxes). In order to check whether your value is present within one of the selected values, use the following structure instead:

//Sub option 1 visible property "Apple" in DataCardValue4.SelectedItems.Value //Sub option 2 visible property "Orange" in DataCardValue4.SelectedItems.Value //Sub option 3 visible property "Cherry" in DataCardValue4.SelectedItems.Value

If this solves your question, would you be so kind as to accept it as a solution. ✔️

If you liked my solution, please give it a thumbs up. 👍

Connect with me: LinkedIn | Blog

Was this reply helpful? Yes No
Poweruser811 34 on at

Like (0)

Report

Re: Visible Formula Not Working

Its not taking the formula, did I miss something?

Was this reply helpful? Yes No
Poweruser811 34 on at

Like (1)

Report

Re: Visible Formula Not Working

Its strange, I reentered it again and it worked. Thank you so much!

Was this reply helpful? Yes No
LaurensM 12,512 Moderator on at

Like (0)

Report

Re: Visible Formula Not Working

My apologies @Poweruser811, it seems that I did not capitalize the I. It should be SelectedItems instead of Selecteditems.

I have adjusted the code in my previous comment accordingly.

Was this reply helpful? Yes No