The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Flow designer retuning only 1k data

MK-p
Tera Contributor

I am fetching data using lookup records activity, but it is retuning only 1000 records but with same condition when i am checking in table then it has more than 1000 records. 

1 ACCEPTED SOLUTION

Runjay Patel
Giga Sage

Hi @MK-p ,

 There is property which has default value to return 1000 records. you can change it but it may impact the performance.

property name: sn_flow_designer.action_picker_limit

 

Share your requirement i may help you with alternative solution.

 

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.


Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

View solution in original post

3 REPLIES 3

Runjay Patel
Giga Sage

Hi @MK-p ,

 There is property which has default value to return 1000 records. you can change it but it may impact the performance.

property name: sn_flow_designer.action_picker_limit

 

Share your requirement i may help you with alternative solution.

 

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.


Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

Hi @Runjay Patel  I changed the value from 1000 to 2000 in the lookup record of flow designer and also in the given system property. But still it doesn't work. Can you plz help here.

 

Requirement- I have a catalog item where we select  var1- group name and var2- user name, so to add users in the given group. Right now the group has 1083 members. when i raise a RITM to add 1 member, the count should increase to 1084, but it doesn't work.

Ankur Bawiskar
Tera Patron
Tera Patron

@MK-p 

It's a platform behavior and is clearly mentioned in docs

AnkurBawiskar_0-1738067187323.png

 

As mentioned by Runjay there is a property which controls this.

It accepts value upto 999999999 but I won't recommend doing that as it will lead to performance impact.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader