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 !!
1. You would need to give some details on these files, their format etc.
2. I noticed that you are first writing the files to disk, and thats ok, not necessary, but ok.
3. In your final Apply, where is that? Where are you getting the value from? Are you listing files in the new folder?
Lets assume the data is the same per file., I do not see details as mentioned so I cannot be educated, but rather guessing whats there.
Is the data in the files json, csv, tsv other?
Once you share that it will be easy to help.
Was this reply helpful?YesNo
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.
Share
Report
All responses (
Answers (
53,315
