Announcements
If( VsrForm.Mode = FormMode.New, LookUp(Vendorlist, 'Vendor Name'.Value = CboVendorName.Selected.Value, 'Vendor Category'), Parent.Default )
What could be the issue.. the on change property of the CboVendor name is below
CboVendorName.Selected.Value
Hi,
I would need some details to help you :What Datasource type is "Vendorlist" ?
The type of the column "Vendor Name" ?
The Items of "CboVendorName" ?This error means that one of your member in your equal operation is a recordSo if "Vendor Name" is a lookup column type, you need to get the column that you want to compare (like name or something), but I would like some precision if you canRegards,
Vendor List: Sharepoint
Column Vendor Name: Single Line of Text
Items of CboVendorName: Distinct(Vendorlist,'Vendor Name')
Thanks ! So you don't need "Value" after 'Vendor Name', since it's already a text field
If( VsrForm.Mode = FormMode.New, LookUp(Vendorlist, 'Vendor Name' = CboVendorName.Selected.Value, 'Vendor Category'), Parent.Default )
Let me know if this works
Not working
OK so maybe the error is somewhere else
What control are you setting the value ? A combobox or a text field ?
And what's the Items property of this combobox ?The result of your formula needs to be of the same type of your combobox items
Distinct(Vendorlist,'Vendor Name')
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 355 Most Valuable Professional
11manish 209 Super User 2026 Season 2
MS.Ragavendar 150 Super User 2026 Season 2
