New Records in Data Table (batch) - Looping through each new record

[RussellJ]

Hi

Another simple question that I just can't seem to figure out 🙄

I have a Recipe that currently triggers when a new (single) record is (manually) created in a Data Table.  And it works very nicely.

I want to modify the solution to handle multiple rows which would be uploaded from a CSV file.

To achieve this I have created another Recipe which detects the upload of a CSV file to filestorage, extracts the lines, and (batch) creates them in the Data Table used by the first Recipe.  This works and multiple new records are creaeted in the Data Table as expected.  But obviously the first Recipe currently just processes the first new record.

So I assumed I would simply return to my first recipe and change the trigger from the (single) "New Record in Data Table" to "New Records in Data Table (batch)" and then use a For Each loop to process the new records.

Except, when I go to the Repeat step and click in the Input List field and browse the output from the trigger step, I can't see a handy array of Records to loop through.

What fundamental principle have I failed to grasp?  And is there a better way to do what I'm trying to do?

Thanks in advance

Russell

[RussellJ · Accepted solution]

Hmmm... looks like I had failed to specify an option for the "Choose the desired output format" field on the trigger!

This was initially left blank when the trigger was changed.  When I chose (either) value from the drop-down I can now see the expected records array/list...

Odd.