Answered

Set SharePoint field based on filename in SharePoint library

(0) Share

Report

Posted on by BClouded

174

Hi Community

I have a list with +-3000 files in a SharePoint library.
The name of the files is a number.PNG or .JPG, so like 1.PNG 2.PNG 3.JPG
I have a new column PropID, which I would like to auto populate with the number before the extension.
Name field is not selectable in sharepoint calculated field so I can not use that do to some string maniplutions.
Any suggestions to get this done automated?

Thanks a lot!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @BClouded

Here is an example:

The Dynamic content 'Name' is the filename without the extension.

After I run the Flow:

Was this reply helpful? Yes No
BClouded 174 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jcook
Thanks you for replying. And sorry for my delayed reply.
Unfortunately I can not use Name as dynamic content... I only see ID and PropID.
I was thinking to something like this
Update PropID -> Left(Title,Len(Title)-4))
Can you guide me once again please?

Thanks!

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @BClouded

Can you try clicking on Title column inside the Update file properties action, and see what dynamic content shows up.

Can you run the flow and give me sample output of your Get files (Properties only) action

Was this reply helpful? Yes No
BClouded 174 on at

Like (0)

Report
Copy link

Link copied!

Well in fact it was part of a solution for migrating an old accdb to sharepoint and powerapps.
Inside powerapps I could indeed see that, ThisItem.Name results in the name without extension. So I could do a lookup in the pictures database with that and each pictures is nicely showing for every record!

Thank yo for your advice! Much appreciated!

Was this reply helpful? Yes No