read csv file in dictionary format using power automate desktop

(1) Share

Report

Posted on by anonymous_12-34

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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report
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