Look Up records

[Darlene York]

Good morning,

I am trying to do a lookup records in flow where if a requestor (requested_for) opens a catalog item (home use) I want to do a check and if the requested for has opened the same request in the past 12 months, the RITM will close incomplete.  Here is my setup, but its not working.

Action:  Look up records

Table:  sc_req_items

Conditions:  

Requested for is 1- Get Catalog requested for

Created relative before 12 months ago

Item.sys ID is sys id of the maintain item

If statement

Condition Label: Look up records is greater then zero

Condition Look up records count (from the set above) greater than 0 

Update requested item record Closed Incomplete.

Thank you

[Ankur Bawiskar · Accepted solution]

@Darlene York 

No need to hard-code sysId of Catalog Item

You can directly use the Requested Item Record -> Item in condition

Flow step looks fine

when it runs in flow context what's the output?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Darlene York]

Thank you, I will try that.