Unanswered

Date to integer conversion in power automate

(0) Share

Report

Posted on by niki1

What is a good date to integer conversion example for comparing 2 dates in the flow. I am using the Created field from Sharepoint and the Utc(Now).

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @niki1

Use the formatDateTime() expression to convert to yyyy-MM-dd.

formatDateTime(utcNow(), 'yyyy-MM-dd')

Similar expression for created field also.

Thanks

Was this reply helpful? Yes No
niki1 18 on at

Like (0)

Report

Thanks for the response.
Do you know how to format the UTC(Now) date to a format like 2023-02-22T17:52:03Z.

I tried your code and still get an error as follows.
Unable to process template language expressions in action 'Initialize_variable' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string 'Created' was not valid. The datetime string must match ISO 8601 format.'.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @niki1

In order to give you an exact answer I need to see your flow screenshot. Could you please post a screenshot of your flow and another screenshot of your failure.

Thanks

Was this reply helpful? Yes No
niki1 18 on at

Like (0)

Report

Hi, I have attached the ss.
Thanks

flow.JPG

flowhistory.JPG

Was this reply helpful? Yes No
niki1 18 on at

Like (1)

Report

It did not work. I tried it with quotes, without quotes, still no go...
The expression "'2023-02-23' eq 2023-02-23" is not valid. Creating query failed.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @niki1

You could still use the same format for comparison but that variable need to declare as string.

If you want to convert to a number then use the below format.

formatDateTime(utcNow(), 'yyyyMMdd')

Was this reply helpful? Yes No