cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fabianartmann
Frequent Visitor

Rename Excelfile with Data from Excel

I am a absolute beginner and would appreciate some help. I would like to automate naming the file name of an excel after a cell from the excel file. The excel comes as an email attachment and is stored in sharepoint. Do you have a solution for me how to automatically adjust the file name with what is in the cell in the file? Thank you in advance.

@v-yujincui-msft@v-qiaqi-msft@v-liwei-msft 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
annajhaveri
Community Champion
Community Champion

@fabianartmann  i would suggest to first save the file in SharePoint from email attachment, then read the file content using "List rows present in a table"  action, to get the file name you want to use and rename the file in sharepoint REST API - reference to rename file https://pnp.github.io/blog/post/how-to-rename-files-in-sharepoint-with-power-automate/

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
annajhaveri
Community Champion
Community Champion

@fabianartmann  i would suggest to first save the file in SharePoint from email attachment, then read the file content using "List rows present in a table"  action, to get the file name you want to use and rename the file in sharepoint REST API - reference to rename file https://pnp.github.io/blog/post/how-to-rename-files-in-sharepoint-with-power-automate/

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,513)