Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Filter array not working

(0) ShareShare
ReportReport
Posted on by 2
Hi,
 
I am trying to find out why my filter array is not working (likely an easy fix). I have created the example below to outline what I am trying to do.
 
 
Where 'Get Items' has been set up like this
 
An the filter array like this
 
 
However, no matter what I do, the outputs are always blank (no outputs)
 
 
Can you help?
  • VictorIvanidze Profile Picture
    VictorIvanidze 11,853 on at
    Filter array not working
     
    item()['field_5/Value']
    but not item()['field_5/value']
  • rzaneti Profile Picture
    rzaneti 3,365 on at
    Filter array not working
    Hi,
     
    I'm not sure if you used the exact same expression that I recommended in the previous message, but it contains a small error: the value is in lowercase, while the V should be in uppercase. This is the corrected expression: item()['field_5/Value'].
     
    Let me know if it works for you or if you need any additional help!


    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Accepted Answer.
    If this answer helps you in any way, please give it a like.

    http://digitalmill.net/
    https://www.linkedin.com/in/raphael-haus-zaneti/
  • DO-17010024-0 Profile Picture
    DO-17010024-0 2 on at
    Filter array not working
    Hi mate,
     
    Appreciate the response but still no Outputs. See it below.
     
    These are the inputs. You can see "field_5" there.
     
     
    And here is the source and criteria.
     
     
    Cheers
  • Suggested answer
    rzaneti Profile Picture
    rzaneti 3,365 on at
    Filter array not working
    Hi,
     
    By any chance, is your filed_5 a Choice type column? If yes, make sure to select the dynamic content of field_5 Value rather than field_5 when populating the filter query. If the dynamic content is not displayed for some reason, you can simply use the expression item()['field_5/value'].
     
    It happens because the choice fields are objects, and its label (what we see in the List) is allocated in the value property of this object.
     
     
    For example, this list:
     
    When filtered by Course Type Value:
     
     
     
    Returns these outputs (no Type 2 found, but a few Type 1):
     
    However, if I filter it by Course type only:
     
    I get no results:
     
     
    Let me know if it works for you or if you need any additional help!


    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Accepted Answer.
    If this answer helps you in any way, please give it a like.

    http://digitalmill.net/
    https://www.linkedin.com/in/raphael-haus-zaneti/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard