Filter by Combobox and SearchBox

(0) Share

Report

Posted on by firda59

372

Hi,

I want to filter my galery based on 'planner combobox' or 'customer combobox' or 'id textinput'. I dont know how to write the formula.

I used this formula in my combobox:

Filter(
ProductID, 
(StartsWith(
'SSB ID ',
SearchSSBID.Text
) || StartsWith('PLANNER ENGINEER',
Planner_1.Selected.Value
)) && 'Dearest Customer' in Customer_Pilihan_1.Selected.Value
)

Can anyone help me? Thank you.

Categories:

Connecting to Data

General Questions

Dataflows

Using Apps Using Formulas

All responses (1)

Answers (0)

Ami K 15,656 on at

Like (0)

Report
Re: Filter by Combobox and SearchBox

Hi @firda59 ,

You have not provided detail of your data source or what the field types are.

If I assumed 'SSB ID ', 'PLANNER ENGINEER' and 'Dearest Customer' are Single Line Text columns, you can use:

Filter( ProductID, Len(SearchSSBID.Text) = 0 || StartsWith( SearchSSBID.Text, 'Single line text column' ), Len(Planner_1.Selected.Value) = 0 || StartsWith( Planner_1.Selected.Value, 'Record Team' ), CountRows(Customer_Pilihan_1.SelectedItems.Value) = 0 || IsBlank(Customer_Pilihan_1.SelectedItems.Value) || 'Record Priority' in Customer_Pilihan_1.SelectedItems.Value )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan