Answered

copy and renaming excel file in the new files

(0) Share

Report

Posted on by Donya

I used a flow to make a folder and include an excel sheet when new info is added. Is there any way to rename the excel sheet and include the folder number in it?

Can someone please help me to make a new flow or modify the existing one.

In the existing one.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Hello @Donya ,

you can rename a file, but you'll need the 'Send an HTTP request to SharePoint' action to do that. The request should look as below:

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

Note: all the <...> parts must be replaced

Was this reply helpful? Yes No
Donya 16 on at

Like (0)

Report

Thanks @tom_riha
, I tried to add it to the existing flow. here is the error :
Could you help me with this thanks

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @Donya ,

it should be the ItemId provided by the 'Copy file' action, not the numeric ID you assigned to the item.

And the list name should be just the list name, inside single quotes.

Was this reply helpful? Yes No
Donya 16 on at

Like (0)

Report

@tom_riha Sorry I still don't know what to put between <> here is the copy file I want to replace "Template" with "Project" number

Was this reply helpful? Yes No
Donya 16 on at

Like (0)

Report

@tom_riha Sorry I still don't know what to put between <> here is the copy file I want to replace "Template" with "Project" number

Was this reply helpful? Yes No
Donya 16 on at

Like (0)

Report

@tom_riha Sorry I still don't know what to put between <> here is the copy file I want to replace "Template" with "Project" number

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

It should be the other way around

And in the URI you should have .../GetByTitle('LineUps')/items(....

And in the FieldValue remove the < and >

Was this reply helpful? Yes No
Donya 16 on at

Like (0)

Report

Thank you @tom_riha 🙂

Was this reply helpful? Yes No