cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LasseChristians
Regular Visitor

Remove X from file name

Hello community,

 

New builder here, and I hope someone can help me with this.

 

I am trying to build a cloud flow, that will delete the last 7 characters from the filename, when a file is created in onedrive (Not counting the file extension. 

I have made the formula in Excel, but I am not sure how I can build similar in Power Automate?

 

I hope someone can help me. Thank you! 

 

 

Substitute.png

 

LasseChristians_1-1622038879113.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @LasseChristians 

 

Try the below expression

 

substring(outputs('Compose'),0,sub(length(outputs('Compose')),7))
 
image.png


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

2 REPLIES 2
abm
Super User
Super User

Hi @LasseChristians 

 

Try the below expression

 

substring(outputs('Compose'),0,sub(length(outputs('Compose')),7))
 
image.png


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

LasseChristians
Regular Visitor

Hi @abm 

 

Thank you very much, it works great like this:

Shorten name.png

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,487)