In this blog, we will learn how to filter a Lookup Field on the New Form.
We have a requirement where there is a Lookup Field on the form, which should only show those values whose Status is Active.
1. This is the form of Quote Product. We want to filter the Existing Product field.
2. To filter the field, click on the Combo Box.
Set ExistingProduct.Items = Filter(<Data Source>,Status = <Field Name>.Active) For eg: ExistingProductQPEditForm.Items = Filter([@Products],Status = 'Status (Products)'.Active)
Hope the above Blog helps you to filter a Lookup Field on the New Form.