Skip to main content

Notifications

Community site session details

Community site session details

Session Id : pzarioPPqmXdRANcLSLmlW
Power Automate - Building Flows
Answered

extract parts of a url

Like (0) ShareShare
ReportReport
Posted on 8 Jan 2020 16:23:27 by 52

I created a Flow that grabs a folder from a subfolder inside one SharePoint library and moves that folder into another subfolder of the same name to another SharePoint library. It works if I hard-code a part of the URL into the destination URL, but I'm trying to grab part of the URL from the source URL in order to append that to the destination URL so that my Flow knows where to put the specific folder based on its original name. 

 

If I have clients AAA, BBB, CCC, let's say I want to grab folder 67890 from client AAA - testsource/Shared Documents/AAA/12345) - and I want to move that into another library -testDestination/Shared Documents/AAA/67890/Coordinator . So 67890 in testSource will be moved into testDestination's 67890 folder that already exists, and will be renamed "Coordinator". 

 

Also, disregard the 12345 in the images or replace with 67890 as this was the first test folder I moved. That will always change.

 

What I am ultimately trying to do is grab the AAA/67890 from source URL or Link to Item dynamic content included in the screenshot. Is there a way to use indexof or lastindexof to do that?First part of FlowFirst part of FlowLast part of FlowLast part of FlowtestSource folder (starting point)testSource folder (starting point)testDestination (endpoint)testDestination (endpoint)Metadata after Flow runsMetadata after Flow runs

  • angelrodriguez Profile Picture
    52 on 08 Jan 2020 at 18:19:11
    Re: extract parts of a url

    Yes, that worked @edgonzales and @abm

     

    1. I grabbed the Link to item or source URL and named it that. 
    2. Took that link and split it - split(outputs('source_URL'),'Documents/')[1]
    3. Grabbing the 'AAA/67890' at the end of the URL
    4. Appended that as Outputs at the end of the Studies/ path like so Studies/Outputs(/AAA/67890/)/Coordinator
    5. This moved the original file to its sister library into the same directory dynamically

    Just wanted to post what I did after following edgonzales' instructions in case other users need to see the steps I took. Thanks, Ed!

     

    Ran successfullyRan successfully

     

     

  • abm abm Profile Picture
    32,464 Most Valuable Professional on 08 Jan 2020 at 17:02:44
    Re: extract parts of a url

    Hi @angelrodriguez 

     

    After the trigger step add a Get File Properties, Select the address and map the id

     

    image.png

     

    Link to Item should return the full path of the filename and URL.

     

    From the compose you could use a split statement using / to extract the values you want.

     

    Thanks

  • Verified answer
    Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on 08 Jan 2020 at 16:59:14
    Re: extract parts of a url

    @angelrodriguez 

    Hi there.  You may want to check out the Split() function if things are consistent enough.  Something like this:

     

    split(outputs('Compose_2'),'Documents/')[1]
     
    Where the stuff in red, you would replace with the dynamic content of your "Source URL".  This will split the URL every time it sees "Documents/" and turn that into an array.  The [1] indicates you want the second part of the array (everything after the delimiter).  Here's a cool video on the function.
     
    Keep us posted.
    -Ed-
     
     

    If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,077 Most Valuable Professional

Leaderboard
Loading started
Loading complete