Flow Designer - If multiple records are found action

AGX-07
Giga Contributor

Newbie here with a question about Flow Designer: I'm going through the process of learning Flow Designer and following a tutorial on ServiceNow Support's YouTube page which shows how to create a basic flow to update Task records when a User's status is changed to Inactive. The version in the video is different than the current version and there are different fields available to me in my lab instance.

 

The basis set up is the same:

 

  • Trigger: User updated where (active changes to false)
  • Actions: Look Up Record > Table: Request > Conditions: Opened by Usser Record

Where I'm getting tripped up is this field that says If multiple records are found action where the only two options are "Return only the first record" or "Fail the step". I don't want to do either of those things. I created two records for the purpose of testing this but I'll want to update both of them. Can anyone explain how I should proceed and/or what the purpose of this field is?

3 REPLIES 3

Astik Thombare
Tera Sage

Hi @AGX-07 ,

 

Steps to update multiple records:

  1. Look up records (Action)
  2. For Each Item (OOB Flowlogic)
  3. Update Record

Please see the following screenshot for a visual representation of these steps:

 

AstikThombare4_0-1699374611095.png

To see if multiple records were updated or not, there is a small checkbox next to the For Each Item step.

 

AstikThombare4_1-1699374871009.png

Please mark  Correct if this resolves your issue, and also mark 👍 Helpful if you find my response valuable based on the impact.

 

Regards,

Astik Thombare

 

Astik Thombare
Tera Sage

Hi @AGX-07 ,

 

Please mark  Correct if this resolves your issue, and also mark 👍 Helpful if you find my response valuable based on the impact.

 

Regards,

Astik Thombare

hitoshis
Tera Contributor

Hi @AGX-07 

I think you are using "Look up record" (for getting one record).
If you want to retrieve multiple records, you can use the Action for multiple records called "Look up records".