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

Power Platform CommunityForums Power Automate Help with substring

Power Automate

Answered

Help with substring

(0) Share

Report

Posted on by annetoal

1,934 Moderator

When the Update properties connector encounters a locked file, it gives an error like this:

The file "https://xxx.sharepoint.com/sites/yyy/zz/site/Test/Book.xlsx" is locked for shared use by user@domain.edu.
clientRequestId: nnnnnnnnnn
serviceRequestId: nnnnnnnnnn

I need help writing a substring that will extract the name of the file, in the case of the example, Book.xslx. Please help!

Ahank you,

Anne

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @annetoal

Use the split() and last() expression

last(split('https://xxx.sharepoint.com/sites/yyy/zz/site/Test/Book.xlsx', '/'))

Was this reply helpful? Yes No

Join the conversation

Community site session details

Help with substring

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Help with substring

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates