Cascading Dropdowns with One being a multpleline text field

Like (0) Share

Report

Posted on 2 Apr 2025 16:23:12 by kmw1130

922

I have 3 combobox I am using for my cascading dropdowns, the 2nd one will depend on a field that is multiple line text field. I am getting the red squiggly line, how would I resolved this?

Categories:

General Questions

All responses (7)

Answers (1)

Verified answer

ronaldwalcott 2,082 on 04 Apr 2025 at 16:51:20

Like (0)

Report

Cascading Dropdowns with One being a multpleline text field

As it's a delegation warning and you are narrowing the number of items first it should not be a concern unless you exceed the delegation limit of 2000 records.
kmw1130 922 on 03 Apr 2025 at 12:53:28

Like (0)

Report

Cascading Dropdowns with One being a multpleline text field

vipuljain03 The Address field is Plain Text.

@ronaldwalcott I filter Vendors, then get their address, and then get the POC.
ronaldwalcott 2,082 on 02 Apr 2025 at 19:20:07

Like (0)

Report

Cascading Dropdowns with One being a multpleline text field

Just a question based on curiosity. Do you have a combo box of addresses that you use to filter Vendors based on a multiple line text field? How do you ensure the correctness of the addresses?
vipuljain03 415 on 02 Apr 2025 at 18:15:24

Like (0)

Report

Cascading Dropdowns with One being a multpleline text field

Check if CompanyAddress being a Multiple Lines of Text is a Rich Text or Plain Text field.

If the CompanyAddress column is rich text, wrap it inside PlainText() to remove any HTML formatting:

Filter('Vendor Info', PlainText(CompanyAddress) = ComboBoxVendorAddrr.Selected)
Or, try below:

Filter('Vendor Info', CompanyAddress = Text(ComboBoxVendorAddrr.Selected))
kmw1130 922 on 02 Apr 2025 at 18:08:42

Like (0)

Report

Cascading Dropdowns with One being a multpleline text field

It is a delegation warning:

It seems to work even with the warning.
kmw1130 922 on 02 Apr 2025 at 17:52:25

Like (0)

Report

Cascading Dropdowns with One being a multpleline text field

@vipuljain03,

That did not work either, if I remove value and add the "." it is suggesting "value"
Suggested answer

vipuljain03 415 on 02 Apr 2025 at 17:39:28

Like (0)

Report

Cascading Dropdowns with One being a multpleline text field

CompanyAddress is a multiple line of text field in your SharePoint list. So, .Value will not work.

Could you please check below formula instead:
Filter('Vendor Info', CompanyAddress = ComboBoxVendorAddrr.Selected)

--------------------------------------

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,

Vipul