Unanswered

Iterate CSV file in power automate

(0) Share

Report

Posted on by krishnakumar_R

108

can some share a flow / share links as how to open and a read a csv file.. I went lots of youtube but there was no clarity

Requirement

open csv and iterate csv file

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@krishnakumar_R - I created a solution -

https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/Get-Rows-Parse-from-CSV-file-using-Power-Automate-and-bulk/td-p/905684

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

Will the CSV that you want to work with always have the same headers/columns?

Was this reply helpful? Yes No
krishnakumar_R 108 on at

Like (0)

Report

Headers will change
Need a generic code / Link to handle CSV

Was this reply helpful? Yes No
krishnakumar_R 108 on at

Like (0)

Report

@CFernandes @grantjenkins - thanks for help.. Vides are awesome.. Here is where i am stuck
after converting to base 64, i get the content but it is a string.. Need them as array so that i can iterate.. The Test file (fed in get file content ) is as below

Test,Url
1,google.com
2,Rediff.com

Was this reply helpful? Yes No
krishnakumar_R 108 on at

Like (0)

Report

I am just following what is said here
https://www.c-sharpcorner.com/article/parse-csv-file-using-power-automate/

why am I getting error

Error Message:
Unable to process template language expressions in action 'Split' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#split for usage details.'.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Try the following expression instead.

skip(split(base64ToString(body('Get_file_content')['$content']), decodeUriComponent('%0D%0A')), 1)

If we work from the inside out:
It converts the content to base64 string
Splits on new line - using decodeUriComponent('%0D%0A')
Skips the first record since that contains the headers (you likely only want the values)

Was this reply helpful? Yes No