Unanswered

Extract Metadata into new SharePoint field

(1) Share

Report

Posted on by CU08031624-0

I am wanting to build a new file file based on: date file created, name of file, and a metadata column that has been assigned to the file by the user.

My flow starts when the file is created or modified.

I have initialized the variable, and performed a COMPOSE function to 'split' the metadata field. Everything fires and I get no errors, but the back in the SharePoint library in the field that I want to update I am seeing the ODATA plus the value that I extracted? I've have fought with this for hours.

Can someone also advise me on how, if I get this to function, how in Power Automate how get the results of the powerautomate workflow to replace the file name with the new, concatenated results?

Many thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report
Hi @CU08031624-0

Please show us the

date the file was created

name of file

and a metadata column that has been assigned to the file by the user.

Please also show the:

output of the COMPOSE action

The expression used in Compose action

the new filename that generated

Ellis Karim
Blog | LinkedIn | Bluesky

Was this reply helpful? Yes No
CU08031624-0 16 on at

Like (0)

Report

This is the flow:

The Variable:

The Compose:

The substring:

The Update to File Properties

The results in the library fields.

Hope this helps with a solution. If anyone can provide it to me.

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Please provide the full split expression used and the full MpartText content so we can figure out where to split this if needed.

However, the content of MpartText seems to be a managed metadata? Is there a dynamic content with the name containing Label available to you from When a File is Created or Modified?

Ellis Karim
Blog | LinkedIn | Bluesky

Was this reply helpful? Yes No
CU08031624-0 16 on at

Like (0)

Report

Here is the express that I built.

The original field is a managed metadata field such as:
1000 Doc1

2000 doc2

3000 doc3

Etc.
I want to split these at the space and the resulting value, to the left of the split needs to update to another field in the document library.

Many thanks

Was this reply helpful? Yes No