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:

Building flows

All responses (5)

Answers (1)

Sort by

Verified answer

v-zhoqian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.
Hauke_Pay 14 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
v-zhoqian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Hauke_Pay 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-zhoqian-msft,

I almost got it. I built the flow but now I am getting an error. Please see the attached screenshot.
v-zhoqian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.