Sharepoint choice columns issue

[DawidK]

Hi,

I have a sharepoint list. Two of my columns are "choice" ones.

I need a function to if i choose GOOGLE on Service Selected i want to make the same choice on Service Affected

but if i choose UNSUPPORTED on Service Selected i want to be able to choose the Service Affected from the dropdown menu.

I am trying to make an IF statement:

!If(DataCardValue28_4.Selected.Value = "UNSUPPORTED_CALLS",DataCardValue28_4.Selected.Value)

but i have an error Expected Table Value.

[WarrenBelz · Accepted solution]

Hi @DawidK ,

I assume you are referring to the Default of the other Drop Down or the DefaultSelectedValue if a Combo Box? You need

If(
   DataCardValue28_4.Selected.Value <> "UNSUPPORTED_CALLS",
   {Value:DataCardValue28_4.Selected.Value},
   Parent.Default
)

On the OnChange of your first drop-down

Reset(DataCardValue28_4)

I have not looked at your logic, just the syntax

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[DawidK]

Thanks for a fast reply.

I should ask for help 4 hours earlier ! You made my night longer. I can go sleep.

Take care.

Thanks alot!

[WarrenBelz]

No problems @DawidK , although 4 hours earlier I would have been asleep (9:30am Monday here in Oz).

[DawidK]

Hi

WarrenBelz

If(
ServiceSelected_1.SelectedItems.Field1.text <> "UNSUPPORTED_CALLS",
{Value:ServiceSelected_1.SelectedItems.Field1.text},
Parent.Default
)

I try to make this one like u told me but know it isnt working

[DawidK]

Also .value doesn't work

[WarrenBelz · Accepted solution]

Hi @DawidK ,

The reference to a combo/dropdown selected item depends on the Items property of the control.

When you type DataCardValue28_4.Selected. (note second dot), valid values will come up underneath. For some guidance of what they mean: -

• If your Items are Choices(ListName.FieldName) - a Choices or Lookup field), the reference will be DataCardValue28_4.Selected.Value
• If they are Distinct( . . .  .), it will be DataCardValue28_4.Selected.Result
• The other option is when they are based on a field value in a list (other than Distinct), then it will be DataCardValue28_4..Selected.FieldName (actual field name)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.