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,

All responses (7)

Answers (0)

chriscooper103 25 on at

Like (0)

Report

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

Hi, I have Simula requirement, is there any chance you could share the solution please?
fchopo 7,968 Super User 2025 Season 1 on at

Like (0)

Report

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

Hi @KD86

Could you post the solution so it could help others?

Thanks!
KD86 14 on at

Like (0)

Report

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

Found the solution, close topic.
KD86 14 on at

Like (0)

Report

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

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.'.
KD86 14 on at

Like (0)

Report

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

Delete
fchopo 7,968 Super User 2025 Season 1 on at

Like (0)

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

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
KD86 14 on at

Like (0)

Report

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

Delete

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates