Skip to main content

Notifications

Community site session details

Community site session details

Session Id : pht8ZY07dleEBzI/aQCa1K
Power Automate - Building Flows
Answered

Use document title to populate metadata field

Like (1) ShareShare
ReportReport
Posted on 29 Jun 2020 01:08:53 by

Hey everyone!

I do not really have a lot of experience with automate, so apologies if this is an easy question.

 

Currently I have documents that have titles with a consistent format. An example is "Agreement - US714 - 38256025 - 06-2020", where US714 is the item ID, 38256025 the user ID and 06-2020 the month and year. When copying these files into our SharePoint, I would like to use this document title to populate some metadata fields inside the document library. I would, for example, like the metadata field "User ID" to automatically have the "38256025" value, the metadata field "item ID" to have US714", etc, by using the data provided in the document title.

 

I got a bit stuck when trying to do this, however , and I was wondering if this is at all possible? I was personally thinking I would have to use the "update metadata" field, but I didn't get it to work.

Any help would be greatly appreciated!

  • Verified answer
    v-alzhan-msft Profile Picture
    on 29 Jun 2020 at 05:58:56
    Re: Use document title to populate metadata field

    Hi @Anonymous ,

     

    You could refer to screenshot below to create the flow:

    1.png

    Expression for the Date as below:

    last(split(outputs('Compose'),' - '))

    Expression for the item id as below:

    first(skip(split(outputs('Compose'),' - '),1))

    Expression for the user id as below:

    first(skip(split(outputs('Compose'),' - '),2))

     

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • rsaikrishna Profile Picture
    3,703 on 29 Jun 2020 at 02:02:05
    Re: Use document title to populate metadata field

    I do not see much details about your flow.

     

    You can achieve your requirement with string function "split". You can find the documentation below:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-split

     

    In your Title, I see you have " - " between each value. You can split the whole string with " - ". Then, you will get an array with each element. You can use the array's individual elements to set your desired fields.

     

    I hope this will help you.

     

    Regards

    Krishna Rachakonda

    If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

     

     

     

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…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 18 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 14

#3
Churchy Profile Picture

Churchy 12

Overall leaderboard
Loading started
Loading complete