You’re offline. This is a read only version of the page.
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 |
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
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)
Share
Report
All responses (
Answers (//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
rpersad
16
#2
David_MA
10
Super User 2025 Season 1
#3
Michael E. Gernaey
8
Super User 2025 Season 1
