Filter a Lookup Field on New Form Using PowerApps.
Introduction:
In this blog, we will learn how to filter a Lookup Field on the New Form.
Use Case:
We have a requirement where there is a Lookup Field on the form, which should only show those values whose Status is Active.
Steps:
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.
Items property:
Set ExistingProduct.Items = Filter(<Data Source>,Status = <Field Name>.Active) For eg: ExistingProductQPEditForm.Items = Filter([@Products],Status = 'Status (Products)'.Active)
Conclusion:
Hope the above Blog helps you to filter a Lookup Field on the New Form.
