web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Collection by M...

Power Apps

Answered

Filter Collection by Multiple Inputs

(0) Share

Report

Report

Posted on by SamBrent

50

Hi,

I'm currently trying to build an app which can filter an ADS table into a collection in the app using mutliple criteria.

This is the formula I currently have to filter by Project Number and this works.

The project number field is mandatory so will always need to be filtered by that first.

I would also like to add an option to filter by the below fields too, but these are not mandatory so some may be left empty when filtering. I can not find a way of doing this so any help would be apprectiated.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

WiZey 3,023 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hello @SamBrent ,

My method to filter on non-mandatory columns is to use "||" operator with "IsBlank()":

Filter( table, column1 = Input1, //Mandatory column, will return records corresponding to input column2 = Input2 || IsBlank(Input2) //Non-mandatory column, will return records corresponding to input OR all records if input is empty )

I hope this was helpful to you.

Was this reply helpful? Yes No
SamBrent 50 on at

Like (0)

Report
Copy link

Link copied!

Thanks @WiZey - That's worked 🙂

Was this reply helpful? Yes No

Join the conversation