Skip to main content

Notifications

Power Automate - Translation Quality Feedback
Unanswered

How to combine content of multiple text files into an excel file

(0) ShareShare
ReportReport
Posted on by
Hi all,

Wondering if anyone can help. I am trying to build a power automate flow that takes text file attachments we receive via email each week, save these files into a SharePoint folder, and then combine the content of the text files into an excel document so that my colleagues can do further work on this.

I’ve been able to get some parts to work, but the bit I’m having trouble with is actually getting the content out of the text files and combining this into an excel file. My knowledge of json and variables is limited, and endless hours of googling has not proved useful :(

I should also note that we don’t have access to any 3rd party apps (which I’ve seen used in many YouTube videos), so I need to be able to do this directly with what Power Automate has to offer.

My flow so far looks like this:



Everything to do with getting the attachments from emails and saving them into SharePpoint works fine, its just getting the content out of the text files and combining them into an excel file I'm having trouble with and don't really know what to do next. 

Any helpers or pointers would be much appreciated !!
Categories:

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard

Featured topics