Unfortunately
FLMike's suggestion will not work with the
With() statement referring to a field inside the filter (the
With is run first and has no idea what you are referring to). You can do it like this, but not in a Delegable manner (you will not get a warning, but the
AddColumns output is restricted by your
Data Row Limit )
Filter(
AddColumns(
[@'DB'],
IDTxt,
Text(EmployeeID)
),
StartsWith(FirstName, SearchInput1.Text) ||
StartsWith(LastName, SearchInput1.Text) ||
StartsWith(IDTxt, SearchInput1.Text)
)
However, the weird thing here is that that code I posted should technically work (it is simply three valid Delegable filters separated by
Or || ), but testing here results in what you have posted. So the code below is a complete unnecessary workaround for what seems a bug, but works as intended
If(
IsNumeric(SearchInput1.Text),
Filter(
[@'DB'],
EmployeeID = Value(SearchInput1.Text)
),
Filter(
[@'DB'],
StartsWith(
FirstName,
SearchInput1.Text
) ||
​​​​​​​ StartsWith(
LastName,
SearchInput1.Text
)
)
)
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