Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Parse CSV File using Column Header Names instead of column Index in Power Automate

(0) ShareShare
ReportReport
Posted on by
I have a  comma separated csv file like below  
 
EMPIDEmpNameEMPCountryEmpSalary 
1TarunINDIA100
2AlexUS300
3JohnUK200

 

currently we are  reading the same values  in power automate using the compose action  after skipping the first row and splitting the data  rows from the second row using comma(",") based on column Index 0,1,2 etc..

 

{
"EMPID": "@{outputs('splitByComma')?[0]}",
"EMPName": "@{outputs('splitByComma')?[1]}",
"EMPCountry": "@{outputs('splitByComma')?[2]}",
"EmpSalary ": "@{outputs('splitByComma')?[3]}",
}

 

Some the csv file may have the same  columns names but in the different order like below 

 

EmpNameEmpSalary EMPIDEMPCountry
Tarun1001INDIA
Alex3002US
John2003UK

 

so I need a way to get the cell values using Column Headers  instead of column Index in Power Automate

 

Any suggestion or approaches please. 

 

Thanks in Advance,

Tarun.

  • takolota1 Profile Picture
    takolota1 4,777 on at
    Re: Parse CSV File using Column Header Names instead of column Index in Power Automate

    There is a part of this template flow where I take in the header names for an existing Excel file, index them, & match them to my input column header names. You may be able to find some inspiration or something you can use from it.

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard