Unanswered

Get date from filename, reverse it, and add it to an item in Sharepoint list

(0) Share

Report

Posted on by KD86

When a file (Excel) is added to my document library on Sharepoint, an automatic flow takes all the data and adds it to a Sharepoint list. So far, everything is working fine.

The Excel file's name I generate contains a date that I want to add to each item in my Sharepoint list. A column is provided for this purpose.

However, I am facing two problems:

1. The file name has other characters (they will always be the same characters, only the date changes in the file name). How to remove the other characters?
File name: xxx_20220407_xxx.xlsx (20220407 = today's date)

2. The date is reversed, I should reverse the date to have 07042022.

In the end, this date should be included in the column provided for this purpose.

I have no idea where to start to get this done.

Thank you in advance for your help,

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

KD86 14 on at

Like (0)

Report
Copy link

Link copied!

Delete

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @KD86

You could follow next steps:

1) Get date from file name using compose action:

split('xxx_20220407_xxx.xlsx','_')[1]

2) Reverse date:

formatDateTime(outputs('compose'),'ddMMyyyy')

where outputs('compose') is the output of step 1.

Hope it helps!

Ferran

Was this reply helpful? Yes No
KD86 14 on at

Like (0)

Report
Copy link

Link copied!

Delete

Was this reply helpful? Yes No
KD86 14 on at

Like (0)

Report
Copy link

Link copied!

I managed to get 20220407 out of the file name.

But I've got an error on compose 2 :
Action 'Compose_2' failed
Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '20220407' was not valid. The datetime string must match ISO 8601 format.'.

Was this reply helpful? Yes No
KD86 14 on at

Like (0)

Report
Copy link

Link copied!

Found the solution, close topic.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @KD86

Could you post the solution so it could help others?

Thanks!

Was this reply helpful? Yes No
chriscooper103 25 on at

Like (0)

Report
Copy link

Link copied!

Hi, I have Simula requirement, is there any chance you could share the solution please?

Was this reply helpful? Yes No