The Lookup Multiple Rows action includes an optional Limit parameter that controls the maximum number of rows returned. [1] You can increase this limit or remove it entirely to retrieve more than 100 records. This limit setting is useful to cut down on response size when you have large numbers of columns, but you can adjust it based on your needs. [2]
Even without explicitly setting a limit, the Lookup Multiple Rows action may have a default behavior that caps results at 100 records. [1] The Limit parameter is optional but when not specified, the system appears to apply an implicit limit. [2]
To retrieve more than 100 records, you'll need to explicitly set the Limit parameter to a higher value or leave it blank to remove any restrictions entirely. [3]
This sounds like there might be an issue with how the limit parameter is being applied. You can click into the specific cell where you're seeing the 100-record output to expose more details about any error messages that might explain why the 1000 limit isn't working. [1]
The Lookup Multiple Rows action should respect the limit parameter you've set, so if it's still capping at 100 records despite setting 1000, there may be an underlying configuration issue or error preventing the higher limit from taking effect. [2]
Thank you, I am basically trying to consolidate call activity data from 2 sources and mapped them to our line of businesses to measure call volume week over week in google sheets