Happy Friday all!

The Search Rows card does not have the logic I'm looking for so trying to find an alternative.

Issue: Limited operator options in the Search Rows card. I need "startsWith" operator logic but the choices are limited to =, !=, <, <=, etc. I want to search a table for location codes but only check the first 2 letters of the location code value.

Theoretical example: A user's location code is HOTX (home office user in Texas) and another is HOHI (home office user in Hawaii). Both are home office employees and should get the same home office location details from the flow table.

I want to see if the first to letters of location value are HO, and if so, grab the location details from the HO row in the linked table.

As things are now (locationCode = location), if the location code is anything other than HO the value result is null. I'd have to add a row for each HO location code variant for each state, and that just seems unnecessary. Does the location code start with HO? Yes? Good, then give them the details from the HO row in the table. Make sense?

Is there another card I can use that would allow me a more customizable table row search? I'd rather not build out a table that needs updating every time we have a Home Office user hired in a new state. I'm eyeballing the List - Filter Custom card that will let me call a helper flow... but checking with the community before I dive down that rabbit hole.

This would be easy to accomplish if the Search Rows card included a "startsWith" operator, or at least let use compose a customer expression or json.