Doubt regarding OOTB data stream (Look up Organizations)

[Ashutosh4]

Hey Guys, I Have a question regarding the data stream company IDs.

there is one OOTB subflow "Get Company IDs" which calls it  "Look up Organizations"

but when I use a custom subflow and call it it returns more record , how is it possible?

And also it gets canceled.

[Tanushree Maiti]

Hi @Ashutosh4 

The custom subflow returns more records because it likely lacks the filtering criteria (e.g., active = true etc)

In ServiceNow Flow Designer, flows can be cancelled if they process a large volume of data that exceeds configured transaction limits. e.g  If the query returns thousands of records, it exceeds transaction limits.

Probable solution

Apply Filter in your custom subflow to minimize the data retrieved.

[Ashutosh4]

The thing is there is not filter applied

There is only this thing which comes in yellow.