Answered

How can I rename an excel file using the flow below?

(0) Share

Report

Posted on by alopez222

160

I have this flow that is triggered by a created item in a list. Basically I am creating a new folder and copying and pasting an excel file into the newly created folder. This works just fine but now I would like to rename the excel file with the name of the folder. The name of the folder will change depending on the Project field in a list within the site. How can I do this?

I have the same question (0)

All responses (3)

Answers (1)

tom_riha 10,179 Most Valuable Professional on at

Like (0)

Report
Re: How can I rename an excel file using the flow below?

Hello @alopez222 ,

you can rename the file with an HTTP request.

Method: POST Uri: _api/web/lists/GetByTitle('<LibraryName>')/items(<DocumentID>)/validateUpdateListItem Body: { "formValues":[ { "FieldName": "FileLeafRef", "FieldValue": "<NewFileNameWithExtension>" } ] }

Was this reply helpful? Yes No
alopez222 160 on at

Like (0)

Report

Re: How can I rename an excel file using the flow below?

While reading the link to the article it says to make the FieldValue equal to a function. This does pop up when I try looking for it. Instead I replaced it with the Project field as seen in picture 2. Unfortunately, this didn't result in what I hoped for. The name of the excel file within the folder isnt the same name as the folder, in this case 0123456.
Results:

Was this reply helpful? Yes No
Verified answer

tom_riha 10,179 Most Valuable Professional on at

Like (0)

Report

Re: How can I rename an excel file using the flow below?

Hello @alopez222 ,

check the action input and output in the flow run history, it should tell you what value you're trying to update and if the update was successful. And you should add also the file extension to the new name.

Was this reply helpful? Yes No