Changing date format from dd/mm/yyyy to dd.mm.yyyy

(0) Share

Report

Posted on by RubenPuertos3

Kia ora team,

Please can you point me if this issue has been solved in the past?

I'm extracting rows from sharepoint into a XLS file and everything is working correctly, except that my client requires that the date extracted from the sharepoint is captured in the excel file as dd.mm.yyyy. I've looked for this solution online unsuccessfully and I was wondering if you guys now how I can get this one done.

My flow is creating a table and then including seven rows from a list (items); one of the columns from those rows is a date (DUE_DATE), I'm attaching a screenshot of the "add row" process.

My question for you guys is, can I change the format as part of the "add row" action?, or should I change the format of all those rows once that the excel file has been generated?

In both cases, can you guys help with some tips about how to do it?

I really appreciate your help 🙂

changing date for...

All responses (4)

Answers (1)

RubenPuertos3 35 on at

Like (1)

Report

Re: Changing date format from dd/mm/yyyy to dd.mm.yyyy

I have marked your question as the answer.

The solution was to change the format type in my formula that I established in the list. I have taken a screenshot of the changes that worked for me.

Thanks Nived 🙂
Verified answer

Nived_Nambiar 17,911 Super User 2025 Season 1 on at

Like (0)

Report

Re: Changing date format from dd/mm/yyyy to dd.mm.yyyy

Hi @RubenPuertos3

Could you please show how the data is added, is it inside the loop or so ?
RubenPuertos3 35 on at

Like (0)

Report

Re: Changing date format from dd/mm/yyyy to dd.mm.yyyy

Thanks Nived,

I made the changes and I got the following error:
The template validation failed: 'The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action, any suggestions there?

error apply to ea...
Nived_Nambiar 17,911 Super User 2025 Season 1 on at

Like (0)

Report

Re: Changing date format from dd/mm/yyyy to dd.mm.yyyy

Hi @RubenPuertos3

In highlighted section use this expression

formatDateTime(items('Apply_to_each')?['Due_Date'],'dd.MM.yyyy')