IF function with two alternatives

(0) Share

Report

Posted on by Francisco77

353

Hi Community,

I need to implement that the value saved in a sharepoint list is depending on the value selected from a dropdown list.
I have this formula, but only when selecting the value "A" the data is recorded (input "Mom_1"), but when selecting the value "B" or "C" all blank values are recorded. What should I correct?.

"Exists Vol": Sharepoint list column name
"Con_1": is the name of the drop-down list, which contains the values "A", "B", "C", and "D".
Mom_1: is the text entry that provides the value to be recorded when "A", "B" or "C" is selected.
Mom_2: is the text entry that provides the value to be recorded when "D" is selected.

OneSelect formula= '¿Exist. Vol?': If('Con_1'.Selected.Value = "A" || "B" || "C" ;'Mom_1'.Selected.Value;'Mom_2'.Selected.Value)

Regards,

Francisco

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Francisco77 ,

Do you want this?

1/Select A, 'Mom_1'.Selected.Value.

2/Select B or C, blank value.

3/Select D, 'Mom_2'.Selected.Value

Please try this.

'¿Exist. Vol?': Switch('Con_1'.Selected.Value; "A";'Mom_1'.Selected.Value; "B";""; "C";""; "D";'Mom_2'.Selected.Value)

Best regards,

Rimmon

Was this reply helpful? Yes No
Verified answer

realwillwright 772 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Francisco77

You can use a switch to select which value you want

Switch( Con_1'.Selected.Value, "A", 'Mom_1'.Selected.Value, "B", 'Mom_1'.Selected.Value, "C", 'Mom_1'.Selected.Value, "D", 'Mom_2'.Selected.Value )

or you could keep it similar to what you had but you need to do an or for all of the values or use an in

'¿Exist. Vol?': If('Con_1'.Selected.Value in "ABC";'Mom_1'.Selected.Value;'Mom_2'.Selected.Value) '¿Exist. Vol?': If('Con_1'.Selected.Value = "A" || 'Con_1'.Selected.Value = "B" || 'Con_1'.Selected.Value = "C" ;'Mom_1'.Selected.Value;'Mom_2'.Selected.Value)

Hopefully one of those options will solve your issue

-------------------------------------------------------------------

If my reply helped you, please give a 👍
If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it.

Was this reply helpful? Yes No