Unanswered

Filter list and send email

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Rahber 1,935 on at

Like (0)

Report
Copy link

Link copied!

Try putting quotes around your variable in filter query

example

USERID eq '[Legajo]'

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
Rahber 1,935 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

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!

Was this reply helpful? Yes No