web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Filter Array simply no...
Copilot Studio
Answered

Filter Array simply not returning any value even though match shows in input

(0) ShareShare
ReportReport
Posted on by 189

I'm really stumped on this one guys. I've done dozens of google searches and poured through the forums here but somehow I have come up short. It seems like a really simple task. Just filter an array from the results on an excel connector output but I have not been able to make it happen.

 

My flow goes like this. PVA gets input from user. PVA calls an action and passes user input into the flow. The flow gets the user's manager and list rows present in a table where users manager matches managers from the excel spreadsheet using oData filter. The flow then tries to filter the output of the excel functions value to only the items where user input (matching column) equals "4". This is where it all breaks down. I'm getting input in the filter array function that clearly shows the user's input (PACOM) has a value of "4" but the output from filter array is empty. I've tried setting the 4 as a string, an int, a float. Nothing seems to matter. I'm completely stuck on this. Any help would be greatly appreciated. TIAshows valid input where "PACOM" has value "4"shows valid input where "PACOM" has value "4"shows valid input where user input Equip_Type equals PACOMshows valid input where user input Equip_Type equals PACOMtrue value 4 attempttrue value 4 attempt4 as string attempt4 as string attempt

I have the same question (0)
  • Verified answer
    kgreen8790 Profile Picture
    189 on at

    Ok, I do feel rather silly now. I have found my mistake. On the filter array function you cannot simply name the key that you are looking to compare values on you must wrap it in the item expression in order to get the function to recognize that what your looking for is an item within the array. So simple and now I feel so stupid for missing that! Here's the expression that worked:

     

     

    item()?[triggerBody()['text_1']]

     

     

     

    Here's a link to the blog that made me realize my mistake:

    Filter an array or collection in Microsoft Flow (sharepains.com)

     

    Thanks to everyone who gave this a look!

    debug1.PNG

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Haque Profile Picture

Haque 106 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 99 Super User 2026 Season 2

#3
sannavajjala87 Profile Picture

sannavajjala87 82 Super User 2026 Season 2

Last 30 days Overall leaderboard