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 🙂

Categories:

Building flows

changing date for...

I have the same question (0)

All responses (4)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @RubenPuertos3

In highlighted section use this expression

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

Was this reply helpful? Yes No
RubenPuertos3 35 on at

Like (0)

Report

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...

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @RubenPuertos3

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

Was this reply helpful? Yes No
RubenPuertos3 35 on at

Like (1)

Report

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 🙂

Was this reply helpful? Yes No