patch and filter

(0) Share

Report

Posted on by Zgolbarg

136

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

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Zgolbarg 136 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
It is a lookup column in Contact list.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Zgolbarg 136 on at

Like
a
(0)

Report
Copy link

Link copied!

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'

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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 } )

Was this reply helpful? Yes No
Zgolbarg 136 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Verified answer

Zgolbarg 136 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes

Yes, it was multiple values.

You are awesome. Thanks a lot

Was this reply helpful? Yes No