You’re offline. This is a read only version of the page.
13
I need what seems to be a unique problem as I cannot find the answer anywhere. I am trying to build a power automate workflow to automatically update SharePoint library metadata columns based on parsing the file name which has multiple underscores as the delimiter. I have a naming convention which is as follows:
Classification_Organization_FileType_Name_Version_Date.
So, the file name would look something like this:
UNC_NGB-J1_Memo_DutyAppointment_v2_20240320.
Each of these elements except for the date has a term store, which creates a drop down list to manually pick from for data consistency when the file is uploaded. I am trying to make the library user friendly by auto-updating these metadata columns based on the elements in the file name. Ultimately, I am trying to motivate my peeps to go through the effort of properly naming these files, which saves them time and effort by negating the need for them to manually assign the metadata directly in the library.
I am having a heck of a time trying to get this done. Any help would be greatly appreciated.
@Nils_Stansen
If you have the underscore delimiter, why can you just use the split() function on the split character?
Share
Report
All responses (
Answers (
