Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Filtering items to then email

Hi, very new to Microsoft flow but i have spent many days researching this and i cannot get it to work how i want it to.


so i have a list created where a new member of staff is created i then use Flow to assign tasks to myself as IT depending on department for example Admin dept new staff require a computer account, office 365 account, ID and Email for example in a task list.


this part works


task list pic.jpg

The issue i have is with the next step i want to then email the person the tasks are assigned to but only of each new record as its created, not all records and off all the tasks for the new employee.


currently i get an email sent to me after each new employee is added of each employee in the task list every time for example i add 1 new user i get one email, i add the second user i will get two emails, user 1 and user 2 and so on.

recieve emails.jpg


Also in each individual email i will see all the tasks assigned to me even if they are not for that user.


recieved email contents.jpg

As you can see under task name it repeats the same 5 assigned tasks 3 times as there are 3 new employees and if i add another employee i would end up with another time all 5 tasks would appear.


below is my flow to send the email, i run two flows, one to create the tasks as new members are added and a second to get the task results once created and then email them, i'm sure it can be done in one flow but i don't know how to get it to work.






Super User
Super User

hi @Mpowis  friend ist is not necessary to get items becouse when you select when a new item is created you have all the data in that row. But if you need to list all the values into all list and send just one email, please follow this example.




then outside apply to each you can add send an email just to one person with all your data inside array variable

Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!

If you want you can follow me at Quieres contenido en español? Síguenos en Power Automate LA

Hi Christian,

thank you for your reply but what is Credo? and i need the email to be sent to who the tasks are assigned to, i have a settings list so when the new employee is created it looks at the setting list for the department.


1. New employee created in Admin department

2. check settings list for tasks related to the Admin department

What To Do?        Department     Assigned To   Email

    - Computer       Admin             IT          

    - Email              Admin             IT          

    - ID                   Admin             IT          

    - Payroll            Admin             HR         

    - Info Pack        Admin             HR         


3. Create Tasks in Task List

Task Name                     Due Date                             Assigned To     Created              First Name    Last Name

Requires Computer        adddays(UTCNOW(), 2)       IT                      UTCNOW()        First Name    Last Name

Requires Email                adddays(UTCNOW(), 2)       IT                      UTCNOW()        First Name    Last Name

Requires ID                    adddays(UTCNOW(), 2)       IT                      UTCNOW()        First Name    Last Name

Requires Payroll              adddays(UTCNOW(), 2)       HR                     UTCNOW()        First Name    Last Name

Requires Info Pack          adddays(UTCNOW(), 2)       HR                      UTCNOW()        First Name    Last Name


4. (the part i'm stuck on)

I want to send an email to IT with the list of tasks they need to do for this new user and an email to HR showing only the tasks they need to do for a newly created employee.


What i want:

New Employee > Tasks > Send Email to IT showing only the Tasks for this new user 


What is happening:

New Employee > Tasks > Send Email to IT showing all tasks assigned to IT for all employees in the Tasks List, then repeat for every employee in the list of new employees





Helpful resources

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,766)