Unanswered

How Formatting dates and percentages in email?

(0) Share

Report

Posted on by Alexsantiago

I built a flow that includes sending emails containing rows extract of an excel. I need to get dates format as dd-MM-yyyy and format percentage number in formar %. The Image shows how the date and number currently appear in the email.

Someone could help me? I need the date to be displayed as dd-MM-yyyy (02-03/2025) and percentage as 4%.

Image below the e-mail:

Thank you very much

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Alexsantiago

Try these below approaches to solve this issue

1st method:

Check whether you have enabled the highlighted option

2nd method: since the date is appearing like that, it is actually represent the how many days your given date is from date 31st Dec 1899 (used in excel), so you can do a calculation to find the date by adding that number of days to 1899-12-31 like below

For percentage you can try same using multiplication on that value and then adding % to it using below method

Hope any of above method works for you

Mark it as solution if it resolves your query 🙂

Was this reply helpful? Yes No
Alexsantiago 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @Nived_Nambiar !

I want to thank you for help me. But, what´s the way, where do I acess it, so that I can acess "Read from Excel Worksheet"?
I can't find "Read from Excel Worksheet" to check and change the information. Could you help me again?
My e-mail is below:

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Alexsantiago

Are you using power automate cloud flow or power automate desktop ?

Was this reply helpful? Yes No