Greetings Power Automate Wizards,
To be completely honest, I have seen a number of threads regarding this issue, but none of them seem to have helped my situation, so I am creating my own. I am building a flow (duh) that when a .txt file is uploaded to a SharePoint Library, it will take the contents of that .txt file, convert it to an Excel document, and (here is where I am having an issue) run a script that will take the contents of the newly created .csv file that converts text to columns and some other formatting things. For more clarification, at a given time, hundreds of .txt files would be uploaded to the SharePoint Document Library at the same time to ensure quick access to them, so there is no time to manually convert each .txt file before uploading, hence the need for this flow.
So far, my steps get me all the way to the "Run Script" step, but that step fails every time. My script file is saved in the same SharePoint Document Library that the .txt files would be uploaded to. Please see both my flow below:
Please let me know if you have any other clarifying questions or a solution! Appreciate you all!
