Split Document name and update month & date into SharePoint Library

[SD29]

Hi Team,

Want to create automated flow .

I have 2 document whose names  are  Document_ABC_20240624 and DocumentABC_06242024. i want to extract & update the month for two different date formats and store them in SharePoint Library column=Month column.

Status column has choices: Urgent & Normal

Also, if Document_ABC_20240624 is uploaded, then status should be urgent & DocumentABC_06242024 then status should be normal.

Please help me to achieve the same as I am stuck

[David_MA]

In your examples, you want to extract 06 from the two different filenames? If so, I can give you expressions to extract the value, but I am not sure how you will determine which one to use for the filename.

When the month is at the beginning of the date value DocumentABC_06242024, use this expression:

substring(last(split(triggerBody()['text'],'_')), 0, 2)

When the month is in the middle of the date value Document_ABC_20240624, use this expression:

substring(last(split(triggerBody()['text'],'_')), 4, 2)

In both expressions, replace triggerBody()['text'] with your filename value.

Both expressions assume two things:

1. The date value is always at the end of the filename.
2. The content before the date value is always preceded with an underscore. It doesn't matter how many underscores are in the filename, just as long the date value is preceded by one.

I have no idea what you mean by: Also, if Document_ABC_20240624 is uploaded, then status should be urgent & DocumentABC_06242024 then status should be normal.

You may want to rephrase that and maybe someone else will have a suggestion.

[SD29]

@David_MA thanks for your quick response.

In my SharePoint Library, I have 4 columns,

Name- Displays name of the document uploaded

Status- reflects choices Urgent or Normal

Month- Reflect month present in document name format

Date- date present in document name format

for example: Case1 If I upload Document_ABC_20240624, then below column should look like

Name : Document_ABC_20240624

Status: Urgent

Month: 06/2024

Date: 06/24/2024

Case2 If I upload DocumentABC_06242024, then below column should look like

Name : DocumentABC_06242024

Status: Normal

Month: 06/2024

Date: 06/24/2024

Whether  a document will be Urgent or Normal is should be based on a Document name format where one will have Urgent one have Word1_Word2_date and Normal one have format as Word1Word2_date.

can you help me build a flow for the same?

[David_MA]

For the month, you can use a concat expression combined with what I posted earlier to achieve what you want. The expression below would be for your Case2.

concat(substring(last(split(triggerBody()['text'],'_')), 0, 2), '/', substring(last(split(triggerBody()['text'],'_')), 4, 4))

You could probably use this expression for the priority. It just counts how many splits there were on the underscore character. If it splits the value into two parts, it would be Normal. Otherwise, it will return Urgent:

if(equals(length(split(triggerBody()['text'],'_')),2),'Normal','Urgent')

You could adapt the above to do the same with the month by replacing Normal and Urgent with the appropriate conact expression.

[SD29]

@David_MA thanks for the quick response on requirement.

may i know what you meant by " In both expressions, replace triggerBody()['text'] with your filename value."

In Dynamic content dropdown, I found only-> Filename with extension & Name. There is no file name.

Which one to use?   

[SD29]

@David_MA  Thanks I am able to save Month for Case2 and Status are getting saved for both case1 & case2.

But Unable to save month for Case 1 when month is middle of date.. I tried with your expression :

concat(substring(last(split(triggerBody()['text'],'_')), 4, 2), '/', substring(last(split(triggerBody()['text'],'_')), 4, 4))

but value is showing as 06/0625... where name of file is Document_ABC_20240625

Also want to extract & save date for both cases in Date field 

Case1

Name : Document_ABC_20240624

Status: Urgent

Month: 06/2024

Date: 06/24/2024

Case2 If I upload DocumentABC_06242024, then below column should look like

Name : DocumentABC_06242024

Status: Normal

Month: 06/2024

Date: 06/24/2024

Can you please help to save the dates for both cases?

[David_MA]

If the action in your flow does not return the file name without the extension, you can add the action Get file properties and it will return a value with just the file name:

Name is the file name as you can see from the description.

[SD29]

@David_MA  

Thanks I am able to save Month for Case2 and Status are getting saved for both case1 & case2.

But Unable to save month for Case 1 when month is middle of date.. I tried with your expression :

concat(substring(last(split(triggerBody()['text'],'_')), 4, 2), '/', substring(last(split(triggerBody()['text'],'_')), 4, 4))

but value is showing as 06/0625... where name of file is Document_ABC_20240625

Also want to extract & save date for both cases in Date field 

Case1

Name : Document_ABC_20240625

Status: Urgent

Month: 06/2024

Date: 06/25/2024

Case2 If I upload DocumentABC_06242024, then below column should look like

Name : DocumentABC_06252024

Status: Normal

Month: 06/2024

Date: 06/25/2024

Can you please help to save the dates for both cases?