Lookup Cost Center is pulling only 100 Records - Workday HR Financial Spoke

Abirami R
Tera Contributor

We are trying to pull the cost center list from Workday to ServiceNow.

In Flow Designer we are using the action "Look up Cost Centers" action to pull the data. When we test the flow it fetches only 100 records. 

We don't see any option to increase the limit of the records it is getting pulled. 

 

Can you please suggest on how to increase the limit for this particular action?

 

Screenshot:

AbiramiR_0-1708943562178.png

10 REPLIES 10

AJ-TechTrek
Giga Sage
Giga Sage

Hi @Abirami R ,

 

If you leave the "Max results" field blank in the Flow Designer lookup action, it will use the default value set by ServiceNow, which is typically 100.

The default value may vary depending on the ServiceNow version and configuration.

Leaving the "Max results" field blank does not mean it will pick up all records. It will still be limited by the default value or any custom value set by ServiceNow. If you want to retrieve all records without any limit, you would need to explicitly set the "Max results" field to a high value, such as 10000 or more.

 

Refer below docs, which may help you on this.

 

https://docs.servicenow.com/bundle/tokyo-application-development/page/integrate/odbc-driver/referenc...

 

https://www.servicenow.com/community/itsm-forum/look-up-records-flow-designer-issues/td-p/485224

 

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

 

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024