Check condition in flow

[PrashantK270430]

If there is a Variable Name "User" references to user table.

condition i need to check is

User is (some different table in servicenow)

How we can achieve this?

[Ankur Bawiskar · Accepted solution]

@PrashantK270430 

let lookup record return only 1st matching

You just want to know if record is present or not

OR

you can use Lookup Records and check the status

Why you are not able to match specific field condition? please share screenshot

[Viraj Hudlikar]

Hello @PrashantK270430 

Since you are having variable, first you need to store value in it and then use that same variable to compare using your if statement.

What have you tried till now? What is blocker for you? Can you share more details?

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Ankur Bawiskar]

@PrashantK270430 

that variable refers to sys_user table

What do you mean by User is (some different tale in servicenow)

Your requirement is not clear. Please explain along with screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[PrashantK270430]

there is a catalog item where i 4 variables one if then User which references to User table.

There is one custom table in platform where there is some field one of them is Employee field there user is coming from user table.

now i want variable User should match with custom table field so that further steps will be created

[Ankur Bawiskar]

@PrashantK270430 

you can get that variable value, query that custom table and see if it matches

Since it's flow you can do this

1) Use Get Catalog Variables action

2) then use lookup on that custom table with proper filter condition

3) then use IF logic to check if the lookup action gave success or failure

Based on that you can proceed further

If my response helped please mark it correct and close the thread so that it benefits future readers.