Unanswered

Split period-separated strings and concatenate them

(0) Share

Report

Posted on by Theresa_SPAdmin

Hello I am using Microsoft Flow and I'm trying to autopopulate a column field in SharePoint.

I have a CSV file with filename in this date format YYYY.MM.DD.csv. When a user saves the CSV file to the SharePoint library, it should automatically update a text column called 'DataString' with string YYYYMMDD (without the periods) based from the filename. The said column is being used in a calculated column for grouping the documents. How do I do this in Flow?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (2)

Report
Hi @Theresa_SPAdmin,

I would offer you the workaround to get the string YYYYMMDD from the file name YYYY.MM.DD.csv,please refer to screenshot below to create the flow:

The expression in the Compose 2 as below:

first(split(outputs('Compose'),'.csv'))

The expression in the Compose 3 as below:

split(outputs('Compose_2'),'.')

The expression in the Compose 4 as below:

concat(first(outputs('Compose_3')),first(skip(outputs('Compose_3'),1)),last(outputs('Compose_3')))

The flow would run successfully as below:

Or you could combine the expression in only one action and you cold create the flow as below:

The expression in the Compose 2 as below:

concat(first(split(first(split(outputs('Compose'),'.csv')),'.')),first(skip(split(first(split(outputs('Compose'),'.csv')),'.'),1)),last(split(first(split(outputs('Compose'),'.csv')),'.')))

The flow would run successfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
Theresa_SPAdmin 7 on at

Like (0)

Report

Thank you so much, Alice! It works like a charm!

Was this reply helpful? Yes No