PowerAutomate & Office Script1
After I was removed from the RPA work, I did not do anything for a while.
But as I continued to live like this, I suddenly wondered, "Is this really how it should be?"
Then, little by little, I began to think about what I could do in my current environment.
In the end, the company environment I was given was...
1. VBA development is prohibited (but can be used)
2. Support for other languages such as Python and Powershell (unknown, probably not possible)
3. Automation Anyware (outside of the scope of work)
4. Power Automate (Cloud environment: Can be used and is actually recommended. However, paid actions such as SAP are prohibited.)
That means it would inevitably be number 4.
For the time being, I put aside access to SAP and other things and thought about whether there was any topic I could use to study.
This is a common part of our work. We access SAP, format the information, paste it into the body of an email, and send it.
First of all, it is prohibited to use actions that access SAP from Power Automate, so this is a manual process. It seems possible to do anything else. So I asked my coworker, Copilot, about it.



That's a pretty high-expectation answer. Maybe I can do this.
Originally, the Power Automate mentioned here has to be on OneDrive.
In that case, I don't want to share the files in my Ondrive with other people. I should link the Excel on the file server to the Excel in my Onedrive.

Comments