Hi,
I have a cascade dropdown: Client name and Bill person.
I have 2 list in Sp clients and contacts.
when a client is chosen based on the condition in the first dropdown, the Bill persons show up in the second dropdown.
I have this formula in the Item property of my second dropdown list
ForAll(
Filter(Contacts, (Trim(drpClients.SelectedText.Value) in Company.Value) And (Bill_To.Value = "Yes")),
{value: 'Full Name',
Id:ID
}
)
here I have a list of some people and I need to choose one of them.
for patch in the submit button, I have this : Bill_To_Person: drpBillToName.Selected
but give me error.
Can you help me with that?
Thanks
Solved! Go to Solution.
So then this means that your Bill_To_Preson column is defined in SharePoint to Allow multiple Value. Please check that in the definition in list settings. If you do not need multiple values, then turn that off in the settings. If you do, then we need to revise the formula and discuss a few other things.
Yes, it was multiple values.
You are awesome. Thanks a lot
First, avoid using the SelectedText property of your dropdown control. It is a deprecated property and should be avoided.
Next, what kind of column is Bill_To_Person in your list?
So let's first alter that formula on the Item property of the Bill to dropdown. It should be:
ForAll(
Filter(Contacts,
drpClients.Selected.Value) in Company.Value &&
Bill_To.Value = "Yes"
),
{Value: 'Full Name',
Id:ID
}
)
This does two things:
1) It gets rid of the deprecated SelectedText property
2) It corrects that you had the Value with a lower case V. Value needs to be uppercase V.
See where that gets you. If the error persists, then let me know what the error is that you are getting.
I've got this error on your formula
on the drpclients give this error: invalid number of arguments: received 1, expected 2
and same error in submit button: The type of this argument'Bill_To_Person' does not match the expected type Ttable' found type 'Record'
There is an extra paren. Sorry about that. Please scrub through the formulas I provide as I type them by hand without the aid of a design editor.
Formula should be:
ForAll(
Filter(Contacts,
drpClients.Selected.Value in Company.Value &&
Bill_To.Value = "Yes"
),
{Value: 'Full Name',
Id:ID
}
)
Yes, I corrected formula before your message and it's fine now, but I have still the error on submit button:
The type of this argument 'Bill_To_Person' does not match the expected type 'Table'. Found type 'Record'
Bill_To_Person: drpBillToName.Selected
So then this means that your Bill_To_Preson column is defined in SharePoint to Allow multiple Value. Please check that in the definition in list settings. If you do not need multiple values, then turn that off in the settings. If you do, then we need to revise the formula and discuss a few other things.
User | Count |
---|---|
260 | |
110 | |
98 | |
56 | |
40 |