Convert utcNow to integer

[brayanrm0097]

Hi,

I'm trying to update the row of the current day in a excel file, but microsoft flow take the dates in the table as number and I don't know how convert the dd/MM/yyyy to a number, how can I do that?

Thanks.

[Jcook]

Hello,

Can you share a picture of your flow,

I am wondering what you mean by flow takes dates as a number.

If you mean you are grabbing the dates from excel and the dates are showing as a long number / integer. You can use the expression: addDays()

For example I always use 2 compose actions.
One for storing the excel number date. And one for doing the conversion. Here is an example

addDays('1899-12-30',int(outputs('Compose')),'MM/dd/yyyy')

Copy my expression exactly. Just change the Outputs(‘Compose’) to your dynamic content.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[brayanrm0097]

Hi, thanks for answer,

I have an excel table with a date column that I want to use for the "Key column" in the excel block, for find the correct row depending of the current day and update the next column.

I tried this simple line for get the current date, but can't use it for the "Key value" because Microsoft flow get date in excel as a number.

[Jcook]

Hi,

Is there an error that you are getting when running the flow?
What format is that column in excel (General,Date,Number)

If possible, I would make the column Fecha a General format, and pass the date as a string by using the expression:
string() infringe of your expression you are using now.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[v-bacao-msft · Accepted solution]

Hi @brayanrm0097 ,

You could use the following expression to covert utcNow() to the number like the value stored in the Date column.

div(sub(ticks(formatDateTime(utcNow(),'yyyy-MM-dd')),ticks('1899-12-30')),864000000000)

Then configure this number in Date column as key-value to update the corresponding row.

Please take a try and see if it helps.

Best Regards,

[brayanrm0097]

That's exactly what I need, thanks!