web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Date Format in PDF Dat...

Power Automate

Answered

Date Format in PDF Data Extraction to Excel

(0) Share

Report

Report

Posted on by digvijaykatiyar

Hello,

I have created a flow wherein I have to extract data from a pdf invoice into excel.

In the pdf document the date field is in dd-mm-yyyy but in the excel it gets converted to mm-dd-yyyy format.

Example- date in pdf is 11-03-2022 (excel value 44631) while in excel it gets converted to 03-11-2022 (excel value 44868)

Kindly provide any solution to above.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @digvijaykatiyar,

Here is two directions for your reference.

1). You could directly format it within your Excel file, select the whole column and right click to select the number format. Choose your format in the dropdown list:

2). You could loop through the Date column and format it as below:

AddDays('1899-12-30',int(items('Apply_to_each')['Date']),'dd-MM-yyyy')

Was this reply helpful? Yes No
Sanj22 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,
I have the same issue and it is not resolved by changing the format as per your first solution.
With regards to your second solution, where would I enter the code you have provided (sorry I am new to Power Automate!)

Many thanks

Sanj

Was this reply helpful? Yes No

Join the conversation