Update File Properties with Value from File Name

(0) Share

Report

Posted on by IPC_ahaas

1,387 Moderator

I am using "List folder" to get all files in a nested folder of a Library.

I am splitting up the values of the name field into multiple Compose actions. This will be used to update columns in the Library for the file.

"List Folder" does not give me an "Identifier" that I need to use "Update file properties". I only get:

* Id

* Name

* DisplayName

* Path

* LastModified

* Size

* IsFolder

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @IPC_ahaas

Try with Id dynamic content 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report
Copy link

Link copied!

I have, the ID field it pulls isn't the ID as it pertains to the Library, so it doesn't work.

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @IPC_ahaas

So you are trying to say that Library name can be changed ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report
Copy link

Link copied!

I'm saying the ID value generated from List Folder

Does not correspond to the Identifier of the actual file.

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @IPC_ahaas

You can try with get files (properties only) action for to get file identifier

And one thing is i observerd is Id and Identifierboth are different , Id always seems to be starting with %252 , while identifier does not start with %252. You are correct

Thanks

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report
Copy link

Link copied!

Get files (properties only) isn't working for me. It does not return the list of files.

Output

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @IPC_ahaas

Just wondering why you are not getting list of files from the folder 🤔 since files are present.

But there is a workaround 🙂

As i told you, the id present as output of List Folder action has %252f at beginning of Id, when i compared the id generated from list files (properties only) it does not have %252f at starting and it is working fine.

So another appraoch you can try is -

Inside the loop, use compose action to remove the first %252f using slice operation

Expression - slice(items('Apply_to_each')?['Id'],5)

Now I am using its output to get file metadata (for my usecase)

And it is working as expected.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report
Copy link

Link copied!

While that process is working for me, the resulting "Identifier" is not. I used the output of the final Compose (which has the Split function) and this is what I get when I try to update a file referencing that:

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @IPC_ahaas

sorry i should have tried that earlier.

Just tried with same for update file properties > it is throwing error.

But i could see a worksaround for this.

see below

I have discussed the same approach > but just extending it

Expression used - slice(items('Apply_to_each')?['Id'],5)

Next i will use itemid which is output get file metadata action in id field of update file properties

As you see above,I am using itemid attribute and then used to update a sample field named Status with value Submitted.

It works for me 🙂

Hope this idea helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report
Copy link

Link copied!

That did the trick! Thank you!

Was this reply helpful? Yes No