Unanswered

How do I retrieve primary filtered data using the dropdown?

(0) Share

Report

Posted on by Huey

If(
IsBlank(FC_Code_Dropdown.SelectedText),
Filter(
'Vehicle 관리 App Vehicle Master',
StartsWith(Vehicle_SerialNo, Search_TextInput.Text) ||
StartsWith(Return_Request_From_Ops_new, Search_TextInput.Text) ||
StartsWith(Vehicle_Type, Search_TextInput.Text) ||
StartsWith(Vehicle_Model, Search_TextInput.Text) ||
StartsWith(Vehicle_Status, Search_TextInput.Text) ||
StartsWith(FC_In_Use, Search_TextInput.Text)
),
Filter(
'Vehicle 관리 App Vehicle Master',
FC_In_Use = FC_Code_Dropdown.SelectedText.Value &&
StartsWith(Vehicle_Type, Search_TextInput.Text)
)
)
 
I am using the same formula as above.
As shown in the first screen, I would like to search for multiple items in the primary filtered list through the dropdown, but only one column can be searched and further progress will not work.
Please help.

스크린샷 2024-1...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Huey

Is this what you are trying to do ?
Filter( 'Vehicle 관리 App Vehicle Master', ( StartsWith(Vehicle_SerialNo, Search_TextInput.Text) || StartsWith(Return_Request_From_Ops_new, Search_TextInput.Text) || StartsWith(Vehicle_Type, Search_TextInput.Text) || StartsWith(Vehicle_Model, Search_TextInput.Text) || StartsWith(Vehicle_Status, Search_TextInput.Text) || StartsWith(FC_In_Use, Search_TextInput.Text) ) && ( Len(FC_Code_Dropdown.Selected.Value) = 0 || FC_In_Use = FC_Code_Dropdown.Selected.Value ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No