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.
Solved! Go to 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.
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: -
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.
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.
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!
No problems @DawidK , although 4 hours earlier I would have been asleep (9:30am Monday here in Oz).
Hi
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
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: -
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.
User | Count |
---|---|
168 | |
96 | |
77 | |
72 | |
59 |
User | Count |
---|---|
210 | |
166 | |
97 | |
94 | |
78 |