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