I have a system that generates a file regularly which is is the format STATIC_RANDOM.zip which contains two files STATIC_RANDOM.csv and STATIC_RANDOM_PARAMATERS.csv where STATIC is alway the name of the report and the Random characters change every time the report is run. The report is emailed to me on a regular basis and I have automated it so it saves in a folder on sharepoint. A further flow then extracts the files from the zip into the same folder. I need to rename the files so they don't have the _RANDOM bit in the filename as I need to connect Power BI to the file and it needs the filename to be constant.
I think Substring might be an option ? but the location of the _ moves depending on the length of the report name
There will be a number of reports and I am struggling to get this to work, have read lots of articles which rename files but they expect the filename to be generally the same but need a date adding on for instance. Any help would be greatly appreciated.
Example of Sharepoint folder
Solved! Go to Solution.
Hi, Thanks for this, it works absolutely as expected. The only issue i have now is that create the file works fine the first time but then fails to overwrite any subsequent time. Any thoughts ?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!