web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Rename Excel file in S...

Power Automate

Unanswered

Rename Excel file in SharePoint based on excel file content (specific cell)

(0) Share

Report

Report

Posted on by Community Power Pla...

Can someone help me with this?

When a new excel file is created in SharePoint, i want to get text content (specific cell) of the excel file and rename the file in SharePoint.

Is this possible with Power Automate? I am grateful for help.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft on at

Like (0)

Report
Hi @Anonymous ,

I assuming you want to rename the file based on the value in cell A3, maybe you could try the following.

1. Here is my excel file.

2. Here is my Flow.

outputs('List_rows_present_in_a_table')?['body/value'][index]?['ColumnName']
_api/web/lists/GetByTitle('Documents')/items(@{outputs('Get_file_metadata')?['body/ItemId']})/validateUpdateListItem
{ "formValues":[ { "FieldName": "FileLeafRef", "FieldValue": "@{outputs('Compose')}.xlsx " } ] }

Result Screenshot:

In addition, here is a link for your reference.

https://powerusers.microsoft.com/t5/Building-Flows/Copy-Past-file-containing-a-certain-string-in-sharepoint/td-p/1686873

Best Regards,

Charlie Choi

Was this reply helpful? Yes No

Join the conversation