Extract data from CSV file by power automate

Like (0) Share

Report

Posted on 24 Jul 2023 14:21:34 by MohamedMo

Dears,

Good day.

i have csv file generated from system by below sequence and picture all in one cell, need to divide data to different cells by power automate tried to create a flow but did not success to divide data any assistance.

Name/Age/Email/Adress

Mohamed/31/test@gmail.com/Cairo

Ahmed/32/test2@outlook.com/Alex

Categories:

Process Advisor

Licensing

All responses (3)

Answers (0)

SanmeshG 1,947 Super User 2025 Season 1 on 24 Jul 2023 at 16:47:47

Like (0)

Report

Re: Extract data from CSV file by power automate

Hi @MohamedMo ,

In that case you have to split the content over , and iterate over each array item and get the value.

Please check out the below thread.
https://powerusers.microsoft.com/t5/Building-Flows/Extract-Data-from-a-CSV-file/td-p/529944

If this helps , please give this answer a thumbs up and accept this as a solution .

Thanks,
Sanmesh
MohamedMo 77 on 24 Jul 2023 at 16:31:35

Like (0)

Report

Re: Extract data from CSV file by power automate

Thanks @SanmeshG for your response it works well but what if i want to extract specific data as Name & Email only
SanmeshG 1,947 Super User 2025 Season 1 on 24 Jul 2023 at 15:55:38

Like (1)

Report
Re: Extract data from CSV file by power automate

Hi @MohamedMo ,

Please refer the below steps.
1. Read the CSV File(Use you data here)
2. Replace the / with comma
3. Create file by passing the content of step 2 in create file action.

Expressions used for base64ToString and replacing / with , (comma)
//To Read CSV File by Converting it to base64ToString base64ToString(outputs('Get_file_content-_Read_CSV_File')?['body']?['$content']) //For Replacing / with , (comma) replace(outputs('base64ToString'),'/',',')

If this helps , please give this a thumbs up and accept this as a solution.

Thanks,
Sanmesh