web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate read csv file in dicti...

Power Automate

Answered

read csv file in dictionary format using power automate desktop

(1) Share

Report

Report

Posted on by anonymous_12-34

6

I have a CSV file with 6 columns, but I only need to work with two specific columns: 'Field' and 'Value'. The 'Field' column contains keys (e.g., 'Name'), and the 'Value' column contains corresponding values (e.g., 'ABC'). I want to extract these key-value pairs and store them in a dictionary using Power Automate Desktop. How can I achieve this?"
Uploaded image

Uploaded image

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @anonymous_12-34

Try like below

Pass the filepath in CSVFilePath variable

You can try by pasting below code to PAD

SET CSVFilePath TO $'''%''%''' File.ReadFromCSVFile.ReadCSV CSVFile: CSVFilePath Encoding: File.CSVEncoding.UTF8 TrimFields: True FirstLineContainsColumnNames: True ColumnsSeparator: File.CSVColumnsSeparator.SystemDefault CSVTable=> CSVTable SET Config TO {{ }} LOOP FOREACH row IN CSVTable SET Config[row['Name']] TO row['Value'] END

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!

Was this reply helpful? Yes No

Join the conversation