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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.