Answered

Rename files automatically in OneDrive for business getting the folder name as a prefix

(0) Share

Report

Posted on by Hauke_Pay

Dear all, I am trying to create a flow where a file, which is saved in a OneDrive for busines folder is renamed and gets the name of the folder as a prefix.

Example: The folder is called "12259G1515" and the file is called "zk.pdf". When I drop the file in the folder, I would like it to have the name "12259G1515-zk.pdf".

I tried various ways, but unfortunately it did not work out. Does someone have an idea how the flow might look like?

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Re: Rename files automatically in OneDrive for business getting the folder name as a prefix

Hi @Hauke_Pay,

You could refer to the following flow:
Expression:
split(triggerOutputs()?['body/Path'],'/')
concat(variables('arr')[sub(length(variables('arr')),2)],'-',last(variables('arr')))

We can separate the path of the file into an array with "/", and concatenate the penultimate and last items into new file name.

Best Regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Hauke_Pay 14 on at

Like (0)

Report

Re: Rename files automatically in OneDrive for business getting the folder name as a prefix

Hi @v-zhoqian-msft ,

thanks for the reply. The flow looks very good. Unfortunately I cannot find compose/compose2 in my actions. Do you know what the problem is?

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Re: Rename files automatically in OneDrive for business getting the folder name as a prefix

Hi @Hauke_Pay ,

It seems that you are not using the English version, so you may not be able to search for 'Compose' action. You could search for the name of the action in your language or switch to the English version.

Best Regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Hauke_Pay 14 on at

Like (0)

Report

Re: Rename files automatically in OneDrive for business getting the folder name as a prefix

Hi @v-zhoqian-msft,

I almost got it. I built the flow but now I am getting an error. Please see the attached screenshot.

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Re: Rename files automatically in OneDrive for business getting the folder name as a prefix

Hi, @Hauke_Pay

It seems that the 'Initialize variable' did not obtain the value of file path. It is null.
Could you share more details about your flow, such as the formulas in each action and the running results of each action.

Best Regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No