patch and filter

[Zgolbarg]

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

[RandyHayes]

@Zgolbarg 

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?

[Zgolbarg]

@RandyHayes 

It is a lookup column in Contact list. 

[RandyHayes]

@Zgolbarg 

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.

[Zgolbarg]

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'

[RandyHayes]

@Zgolbarg 

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
    }
)

[Zgolbarg]

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

[RandyHayes · Accepted solution]

@Zgolbarg 

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.

[Zgolbarg · Accepted solution]

@RandyHayes 

Yes, it was multiple values. 

You are awesome. Thanks a lot