This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
There's an easy (non-batch) work around for this. It relies on the feature that the Dynamic Input tool batches and unions all the results together. So rather than inputting 1 record with 2700 conditions into the Dynamic Input (which doesn't work), make 3 rows with <=1000 conditions in each and the Dynamic Input tool will output them all together.
I've attached an example solution I built last week to show how to use a RecordID and Formula tool to achieve this.
I got it to at least start processing. I have gone through your workflow many times to see the data types and see that they are all wrapped in quotes at the end. My data types are literally the same as yours, but cannot get them to do this. At thigs point they are just showing as example:
With this method, are we doing queries multiple times, vs one query and looking at the resuls?
If you're using the solution I posted to create multiple records, each record going into the Dynamic Input is a query that is executed. The Dynamic Input will execute those queries one by one, then the results from all queries are union-ed together before they are output from the tool. This process should be indicated by the Results window that outlines each query executed.