Trigger Condition: Column Value is greater or equal to a Lookup Column Value

(1) Share

Report

Posted on by jamescosten

643

I have a Sharepoint List with a lookup column. This pulls through a number and I would like my flow to send an email if this columns exceeds 2000 when its submitted.

SP Column:

I get this error:

Any ideas on how to achieve this?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please modify to this format (you don't need float):

@greaterOrEquals(triggerOutputs()?['body/Tool_Weight'], 2000)

^^ modify the column reference above to match you List column

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report
Copy link

Link copied!

Hi, I changed it and get this error.

Was this reply helpful? Yes No
Suggested answer

trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Ok, the root cause here then is the item in your List that doesn't have a value. Please check your List for the triggered item.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
jamescosten 643 on at

Like (1)

Report
Copy link

Link copied!

This is a lookup column and I cannot set a default value so the missing information is blank. Can i adjust my flow to filter blanks before the check for weight is doen? What would this look like?

Was this reply helpful? Yes No
Suggested answer

trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes you can do a conditional action before by using the following:

length(Dynamic_content_column) greater than 0, shown below in this example.

length() is a helpful conditional expression. So in my example, I don't want to run the apply to each unless there were items returned in my Get Items.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report
Copy link

Link copied!

Thank you, But in your example you have used manual trigger. How would i get it to work with When an item is created trigger?

Was this reply helpful? Yes No
trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey there!

I am following up on this post trigger condition: column value is greater or equal to a lookup column value in this category building flows from 10/24/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 6 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No