Extract properties from filename and tag SharePoint metadata

(0) Share

Report

Posted on by Community Power Pla...

I built several workflows in SharePoint designer that extracted information from the filename and tagged the file with the appropriate metadata.

For example:

Doe, John - 8Hr Safety Training Course 2021-08-26

When I built this in SPD, I used the location of '-' to figure out where to extract the person's name, the location of 'Hr' to extract the hours, extracted the date off of the end since it is always a fixed number of characters, and extracted the name of the course using the 'Hr' location and the fixed position of the date from the end of the string.

I have extracted the course hours and the person's name, but have not been able to extract a specific number of characters from the end of the string.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (0)

Report

Re: Extract properties from filename and tag SharePoint metadata

Hi @Anonymous
If you want to get the date from 'Doe, John - 8Hr Safety Training Course 2021-08-26',you can refer to:
Expression:sub(length(outputs('Compose')), 10)
Expression:substring(outputs('Compose'), outputs('Compose_2'), 10)
Result:
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No