Flow designer - check for an existing request record before inserting a new one?

[Abilash Kankipa]

Hi All,

I am running into an issue when checking for an existing record in the target table and if no record found then, insert a record using Flow Designer. 

I am using lookup record and If condition to check if there is a field match (both source & target field type are string ) and value exists in target record. But the condition is failing and it inserts record every time.

Requirement is, if an employee with today's term date record is been inserted in servicenow table then, automate creating a request with auto filling the details from that table. If a request already exists then ignore inserting another record.

[Claude DAmico]

Rather than use a flow, a Business Rule could easily accomplish this.

Since you are using a flow, I would use the Test at the top of the Flow Designer page for the flow to ensure the data being collected and populating the data pills are the correct sets of data. Are you able to share a redacted output of a Test? I'm thinking the resulting data pill and the "is not 1" part is where we will find the problem.