Flow Designer>>Look Up Record>>Flow stops in error if no record found

Stefan K_
Tera Expert

Use case: I want to check if a certain record exists

  • If yes, update another record by inserting the look up record to a reference field
  • If does not exist, do something else

Problem: When using "Look Up Record" function, if there is no record found the whole flow stops with error:

find_real_file.png

Question: What is this error? I only noticed it happens if no records found. Is this by design and if yes, how should you manage a situation to check if something exists and continue if doesn't? Look Up Record(s) is not usable because you can't use it as a data pill to populate a single reference field.

3 REPLIES 3

Community Alums
Not applicable

I'd suggest you do use "look up record(s)" in a way similar to this: 

 As you can see, you can still then use the data pill to reference the record. 

Marshall Burns
Kilo Explorer

Where do you get "Count" from?

Ok I see, I was doing just look up record, instead of look up records so there was no count.  If you only want to look up a single record it doesn't seem like you can tell if you got it or not.