I need to upload 700+ rows of data from the front end through a workflow.
My current plan (Professional) doesn’t seem to allow this, so a workaround I thought of was to create the data in batches of 100.
My workflow is set up like this:
When button is clicked,
Schedule API workflow on a list: from item#1 upto item#100, on current date/time
Schedule API workflow on a list: from item#101 upto item#200, on current date/time +30 seconds
Schedule API workflow on a list: from item#201 upto item#300, on current date/time +60 seconds
Schedule API workflow on a list: from item#301 upto item#400, on current date/time +90
…and so on until #700.
In theory this should work, but everytime I run it it always doesn’t finish the workflow. It will only create 200-300 things and then stop entirely.
What I’m also confused about is that if the Scheduled API worfklows just didn’t fire, then the data count should stop at a fixed number (100, 200, 300 etc), but it is always stopping at a arbitrary number so I assume there’s something going on behind the scenes.
Can anyone help?