I have a flow. It pulls in PO data from an API. I have the steps set up like this:
1 - pull api data
2 - iterate across each PO
3 - filter based on criteria
4 - iterate across each row (multiple items on each PO)
5 - create variables that reformat 3 different fields
6 - create variable that collects all the fields (here’s where things seem to go off the rails - I’ve tried both with and without steps 6 & 7 and get same results)
7 - array aggregate the variable from step 6 (this was set up because of the problem I’m going to explain at the end)
8 - create csv advanced - I define header fields, and tell it what fields I need to populate each field
9 - drop file to google (create file from text)
In my sample data I have 1 PO and 3 lines on that PO. I am getting 3 csv files. One for each row. I’ve tried with and without step 6 - I get the same results. (PS, my Create file from Text on Google Drive ALWAYS creates a .txt, even if I name file .csv in the function)
Please help!