web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter ADS Table by Mu...

Power Apps

Answered

Filter ADS Table by Multiple Combo Box Selections

(0) Share

Report

Report

Posted on by SamBrent

50

Hi,

I am currently building an app which will filter an ADS table to return results by a selection of filters.

This is the current formula I have which will filter by a range of different fields.

However, I am requiring the Job Number field to be changed to a combo box in which users will be able to select multiple job numbers to filter by. The job number combo box will be filtered to the jobs which sit within the inputted project number. I have been unable to find a way to filter my table/collection by multiple job numbers, so currently it is set to a free text input which allows only one number to be entered.

Any help massively apprectiated.

Thanks

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @SamBrent ,

Items of the Job number Combo box:

Distinct(Filter(ADStable, ProjectNumber = PorjectNumberInput.Text || IsBlank(PorjectNumberInput.Text)),JobNumber)

The button to navigate to another screen:

ClearCollect(TransferLinesCol, Filter(ADStable, ProjectNumber = PorjectNumberInput.Text || IsBlank(PorjectNumberInput.Text))&& JobNumber = JobNumberCombo.Selected.Value && OtherCriteria)); Navigate(...)

Best regards,

Join the conversation