For Each loop sending sysid of the record

ARAVINDA11
Tera Contributor

@Ankur Bawiskar  @Community Alums  @Sohail Khilji  @Maik Skoddow  or anyone please help its urgent

 

I configured flow with LOOKUP RECORDS to COMPANY TABLE with the condition starts if vendor is true

 

in the table i can see total count  was 4800 but in Flow for each it is reading only 1000 records only that too after reading the 4-5 data it is sending only the sysid of the record which is weird please help me how can i achieve to get the list of records available in COMPANY TABLE WITH THE VENDOR IS TRUE CONDITION

 

ARAVINDA11_0-1718350314431.png

 

3 REPLIES 3

Maik Skoddow
Tera Patron
Tera Patron

Lookups in Flows are restricted to 1000 records only due to performance reasons. Please refer to https://docs.servicenow.com/bundle/washingtondc-build-workflows/page/administer/flow-designer/concep... for more information.

As a workaround, you can implement the approach demonstrated in https://www.youtube.com/watch?v=Bd_Cq2qyNDk 

Are you looping in Flow Designer for the best performance? Watch this video to see an AMAZING difference between looping in a flow versus looping in a SUBFLOW in CHUNKS! I did this to optimize my ServiceNow Store Application crawler and I thought I'd share what I learned with all of YOU! ...

@Maik Skoddow  That is fine we can increase the size in lookup execution i can see it is sending as a name but in for each loop i can see only the sysid why it is not sending the company records

How can we answer your question, if you don't provide more details like everything around your Flow and its configurations? We cannot read your thought, cannot see through your eyes, and we have no access to your instance!