Filter a Lookup Field on New Form Using PowerApps. | CloudFronts

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.


Share Story :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close