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 / Power Automate / Filtering List By an A...
Power Automate
Unanswered

Filtering List By an Array

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I have a flow with an array. I would like to use the values contained in the array for a condition control. If the values in the array match DO NOT match what is found in a sharepoint column, the flow is to send an email for each item. The array is first converted into strings using split. The string is compared to the title column. See below:

 

shuhn1229_0-1663697804354.png

 

The problem I am getting is that despite the condition is being properly marked (returns TRUE, FALSE, TRUE when the successful flow is triggered), I am getting an email for all three of the conditions. Additionally, The flow is triggering twice, and I am receiving duplicate emails.

Categories:
I have the same question (0)
  • Sundeep_Malik Profile Picture
    6,499 on at

    Hey @shuhn1229 

    This is happening because there are two loops.

    Is there a way to reduce those two loops?

    And above you have written, you have used split to convert array to string, but its not correct, whenever you use split on something, it is converted into an array.

  • shuhn1229 Profile Picture
    on at

    Hi,

     

    thanks. when I drop a loop the condition doesn't seem to be working, it returns everything as false. For reference here is how the array variable i'd like to use the condition control in the list by is setup:

    shuhn1229_0-1663699512667.png

     

    And here is how the condition is setup (in this case just returns false, which is incorrect):

     

    shuhn1229_1-1663699631278.png

     

    How would you approach this?

     

    THANK YOU!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard