Look up record is not working in flow designer.

[jugantanayak]

Hi,

I have a requirement to restrict the duplicate records entry to Hardware model table through flow designer.

But my logic is not working.

Kindly suggest.

Screenshot of flow designer has been attached to this post.

Best Regards,

Juganta Ki. Nayak

[ReginaldFawcett]

Hi jugantanayak,

I assume the issue you are having is with your IF statement and the count of records coming back.

Can you run a test against a record you know is a duplicate and check the "count" variable in the test results?

To do this click Run Test at the top of the screen in Flow Designer. Select a record you know has a duplicate and run the test. Then click on view results. Navigate down to the Look up Record step, and check the outputs for the count.

You may need to adjust your IF statement, or maybe your records are not matching precisely.

Hope this helps.

[OlaN]

Hi,

I would try changing the conditions on the look up record action. Instead of using "is same as" I would use "is".

Look at the execution records, to see what the values turn out to be when you run it.

Both Manufacturer and Model categories are sys ID comparison, so these should work out fine, as long as your variables are reference values. The Name is a String comparison, which could fail comparing upper and lower cases for instance.

When working with string comparison, the option "is" actually doesn't care about cases, so it would return true comparing "text" with "TeXt". But using "is same as" does fail, because it is case sensitive.