itil

ITIL Reporting

excel

ITIL 4

excel

Power BI

excel

Excel Formula | Macro | Script

Power Automate: rename an excel file in sharepoint

To rename an excel file, first, I need to know its “ID”. In the sharepoint, click on the “down arrow” near “all documents”:

power automate

Click on “add or remove fields”:

power automate

In the list, select “ID” then click on “apply”:

power automate

And this is the “ID” for the file that I want to rename:

power automate

In Power Automate, I will select this option to start my flow:

power automate

Click on the “+” to add a new action:

power automate

In the “search” field, put “sharepoint send http” to select this option:

power automate

Fill all fields:

  • Method: select “post”
  • Uri: _api/web/lists/GetByTitle('WW')/items(XX)/ValidateUpdateListItem
    NOTE: change “XX” by the ID of your file and “WW” by the “root folder”
  • Advanced parameters: click on the field to select “body”
    power automate Then put this code (change “YY” by the new name): 

{
  "formValues":[
      {
          "FieldName": "FileLeafRef",
          "FieldValue": "YY"
      }
  ]
}
power automate

After clicking on “save” then “test”, this is the result:

power automate

Interesting Topics