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

Filter list and send email

Hi, everyone! I made a flow that triggers when a new item is added to my list "RetornoFlexible_1". I need to take the "Legajo" from that item and look it up in another list called "TablaEmpleados". When Legajo=USERID, my flow should save the MANAGER in a variable called "superiorid". After that, I look up the "superiorid" in the USERID column of "TablaEmpleados" list, get the "EMAIL" and save it in the variable mailSuperior. Finally flow should send an email to the direction saved in mailSuperior.

This it how it looks



My problem is when I execute the flow, although it detects no error, the result of my first filter (Legajo = UserID) gives back a null. So no email is sent.  I now for sure that there is a userID equal to the legajo value i'm trying so I don't why this is happening. Could you please help me?



Thank you!





Super User
Super User

Try putting quotes around your variable in filter query


USERID eq '[Legajo]'

Hi, @Rahber ! Thank you for your reply, I put the quotes but it still doesn't work.





@Rahber do you know if there is a limit in the amount of rows that "Get items" can process? My list has at least 11000 items. I only need to get 1 item though. Thank you! 

There is usually a 100 items default limit that can be increased to 5000 by enabling pagination in the settings of the action.

The problem seems to be some thing else in your case. Can you remove the filter and show the body of the action in run mode specially where the USERID is shown ?

Hi @denise_martinca 


If you want to get only 1 record at a time, then you can set the Top Count property of the Get Items action to 1.



Hope this Helps!


If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (943)