If you have array based values in custom fields defined by ACF (as i can see from your screenshot), you will want to write meta query with LIKE as compare instead of IN.
I’m assuming your “providers” post type looks something like this:
Here is your example written with LIKE compare:
<?php
$search_args = array(
'posts_per_page' => -1,
'post_type' => 'providers',
'post_status' => 'publish',
'orderby' => 'title',
'order' => 'ASC',
'meta_query' => array(
'relation' => 'OR',
array(
'key' => 'industry',
'value' => 'financial_services',
'compare' => 'LIKE'
),
array(
'key' => 'primary_functionality',
'value' => 'platform_decision_engine',
'compare' => 'LIKE'
)
),
'suppress_filters' => true
);
$the_query_search = new WP_Query( $search_args );
while($the_query_search->have_posts()) : $the_query_search->the_post();
echo get_the_title() . '<br>';
endwhile;
?>
Refer to https://www.advancedcustomfields.com/resources/query-posts-custom-fields/ for more information on custom field meta queries.