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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter array e-mail au...
Power Automate
Unanswered

Filter array e-mail automation

(0) ShareShare
ReportReport
Posted on by 792

Hi 


I have a flow where I am getting items that are filtered by Odata on a column to return only open items. I have then initialised a variable then used the apply to each to append the data to the variable which is working as expected. However I then want to filter the array to enable me to send personalised e-mail based on the open items so in effect the outcome will be one e-mail per person with a table outlining each open item.

Is anyone able to advise the best approach to gain this outcome?

Categories:
I have the same question (0)
  • ChristianAbata Profile Picture
    8,951 Most Valuable Professional on at
    Re: Filter array e-mail automation

    hi @Kmayes  did you try maeby filter array action?

    filter array.PNG

  • Kmayes Profile Picture
    792 on at
    Re: Filter array e-mail automation

    Hi@ChristianAbata 

     

    Yes  I appended all get items to a variable then added the action to filter the array. However there is multiple users to filter by therefore I don't want to have to make multiple flows. At a guess i would need a variable to define the user the end e-mail will go to?

    4.JPG

  • ChristianAbata Profile Picture
    8,951 Most Valuable Professional on at
    Re: Filter array e-mail automation

    mmm I understand @Kmayes  how many user you have to filter? because you can use parallel flow option.

     

    parallel brach.PNG

  • Kmayes Profile Picture
    792 on at
    Re: Filter array e-mail automation

    @ChristianAbata 

    There is likely to be up to 10 different users, how would you propose to a parallel action to be applied?

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard