Extract data from CSV file by power automate

(0) Share

Report

Posted on 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:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!
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

1 people found this reply helpful.

Was this reply helpful? Yes No
MohamedMo 87 on at

Like (0)

Report
Copy link

Link copied!

Thanks @SanmeshG for your response it works well but what if i want to extract specific data as Name & Email only

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No