web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / parse several csv file...
Power Automate
Unanswered

parse several csv file contents from 'Apply to each' statement

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

 

I have several csv files in different folders under one main folder in sharepoint. All the csv files contain the same headers and have different user-information. I need to append the different csv files to one main table and save it into the DataVerse database.

 

I made a workflow that does the following:

 

1. It lists the folder and gets for each file in the folder the file content

Screenshot 2023-01-26 115502.png

base64ToString(outputs('Get_file_content_using_path')?['body']['$content'])

 

The output of this step gives the csv file content of 28 csv-files. 

 

2. I try to split the output of each file into rows with the following statement

Screenshot 2023-01-26 115746.png

split(outputs('Compose_content'),'')

 

I get the following message when i try to safe my workflow:

Screenshot 2023-01-26 115957.png

 

Does anyone know what i am doing wrong?

 

I appreciate the help!

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard