If you want to add all rows of csv to excel table- refer below flow
For demo purposes- i have used the csv file
Also an excel table is created with simmilar column for storing data
Follow the steps as shown below
1. use the trigger when email arrives
2. Use filter array to filter out the attachments which are of csv type.
3. use apply to each loop to loop through each filtered array output.
Next steps will be used inside the apply to each loop
3.1- use get attachment to get attachment content
3.2 use compose action to convert the base64 attachment content to string as shown below
3.3- Use apply to each loop again to loop through each row in csv file after split operation.
following steps would be under above apply to each loop
3.3.1- use add row to table to add the row details to table as shown below
Note - after the split operation - that removes header and each element would be of format ['1,2,3','4,5,6']
Now for '1,2,3' - 1 should be in A column, 2 should be in B column and 3 should be in C column. so we should split it using , as delimiter and take index values accordingly as shown above.
After running the flow - it should be look like this
Thanks & Regards,
Nived N
Stay connected:
LinkedIn | YouTube | Blogs
Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!
