Here is my Flow. After generating the CSV table. I would want to parse it and use its fields as variables on my "Apply to each"
Whole Flow
Expanded Flow 1
Expanded Flow 2
Expanded Apply to Each
Here is my Flow. After generating the CSV table. I would want to parse it and use its fields as variables on my "Apply to each"
Whole Flow
Expanded Flow 1
Expanded Flow 2
Expanded Apply to Each
You can use Parse CSV action from Plumsail Documents connector. It allows you to convert CSV into an array and variables for each column. Please read this article demonstrating how it works.
Then you can iterate through the result array and read all values as you need.
Hi @v-zhos-msft,
My current process is already getting the parsed items from the body.
My goal was to have the csv table as source so the API will get data on the csv table source instead of getting data from the parsed items. Is that possible? Thank you.
Hi @Anonymous ,
As the pic shown, the csv data is come from 'user' of the 'Parse items'.
So you can use the body of 'Parse items' as source in the apply to each, then you can get the dynamic content of 'user'.
Best Regards,
Community Support Team _ Zhongys
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
WarrenBelz
146,695
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,015
Most Valuable Professional