Rename multiple files with different names

(0) Share

Report

Posted on by deeppawar

Hello,

I have been working around with some file which i have connected to power BI.

I download the files daily (the files are downloaded with a suffix of today's date).

Is there any way to automate this stuff , means the trigger will look for a a particular text in that folder, if found then rename it by removing the suffix. (this needs to be done for 10 files)

Example : the file named "CustomerRegistrationSummaryReport01022022.xlsx" needs to be renamed to "CustomerRegistrationSummaryReport.xlsx"

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @deeppawar,

Do you want to remove the date numbers from the file name?

Where do you save this download file, SharePoint or OneDrive?

Actually, there is no OOB function or action to extract numbers from a file name. If you have set the date number as a fixed format like 8 digits, you could try a solution as below.

concat(substring(outputs('Compose'),0,sub(length(outputs('Compose')),13)),'.xlsx')

Note that I assume that you have format date number into 8 digits, so you should count 13 for the file name except for the string part.

Was this reply helpful? Yes No