Look Up records in Flow designer not working as expected

MGR
Tera Contributor

Hi Every one,

As am using list collector variable need to get the values from list collector variable and pass the variables values to look up records action in flow designer when am passing values to the action its giving only one record please refer the below screen shot for the reference.

 

MGR_0-1737886602227.png

HI @Ankur Bawiskar,

Please look into the above it will be help full.


1 REPLY 1

Viraj Hudlikar
Giga Sage

Hello @MGR 

In my PDI I created dummy list collector variable reference to user table. Now when its submitted I am trying to execute flow which will iterate through value in list collector and showcase some information.

Below is screenshot to understand more in better:

1) Catalog Item form and selection done before submitting.

VirajHudlikar_0-1737908473088.png

2) My Flow structure first get catalog variables then lookup on incident table where active is true and caller.sys_id is one of (values from list collector) directly passed then for each loop on lookup of incident records and in log statement printing value like INC number and caller name.

VirajHudlikar_2-1737908692657.png

3) Execution results as below:

VirajHudlikar_3-1737908760421.png

VirajHudlikar_4-1737908788273.png

 

Also do check this KB https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0962340

which will be helpful to understand working of list collector during iteration. 

 

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.