POWER AUTOMATE - Convert date from array (44551) to integer

(0) Share

Report

Posted on by LNeaga_Next

Hi all,

We have built a flow through which, when an invoice is received by e-mail, is saved in one SharePoint folder, is read using Predict (invoice date/ invoice number), and all the information is added in one excel table.

After this we want to send via e-mail all the information(invoice number, invoice date, value) in one HTML table.

The invoice number is ok, but the date appears like 44411.

What we want to do is to convert this in number in date. We used an initial date (1-1-1900) and using AddDays we want to create the date. The problem is that we have multiple invoices, and the information appears like arrays and we need it like "integer".

How can we convert arrays in integer and calculate the date for each invoice date in the same time?

after the flow runs, appears like this!

Thank you!

Lizica

Categories:

General topics

All responses (1)

Answers (0)

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LNeaga_Next,

You could try and move the adddays expression to your mapping in the select action?

Below is an example of that approach:

addDays('1-1-1900', int(item()), 'o')