Get Posts by multiple custom fields is not working

by

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:
enter image description here

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.