Renaming Files in Sharepoint using Power Automate

[Bluestone]

Hi,

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. 

Simon

Example of Sharepoint folder

[v-xiaochen-msft · Accepted solution]

Hi @Bluestone ,

I did a test for you.

concat(substring(outputs('Compose'),0,indexOf(outputs('Compose'),'_')),substring(outputs('Compose'),indexOf(outputs('Compose'),'.')))

Best Regards,

Wearsky

[Bluestone]

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 ?

Simon