Answered

How to initialize Date Type variable

(2) Share

Report

Posted on by Community Power Pla... Microsoft Employee

There is no "Date Type" when creating/initilizing variables. Is there any way to work with Date types(adding, subtracting time from existing dates in the lists)?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

vecerpa 786 on at

Like (5)

Report
Copy link

Link copied!

Hi @Anonymous,

Yes it is possible to work with datetime from list, for example below I used created on item of sharepoint list.

Just use string type and then you are open to use datetime functions - https://docs.microsoft.com/cs-cz/azure/logic-apps/logic-apps-workflow-definition-language.

There s like adddays(), formatdatetime(), addhours(), addminutes()...
Hope this helped a bit
P.

Was this reply helpful? Yes No
vecerpa 786 on at

Like (1)

Report
Copy link

Link copied!

And there is also a set of Date Time actions that I forgot...

🙂
P.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks so much for your help! Your screenshots with comments were very helpful.
Is there any source for learning syntax used in the expressions? For example, using variables or field values inside addDate() expression was not something that I could have seen in internet or Flow documentations.
Thanks!

Was this reply helpful? Yes No
Verified answer

vecerpa 786 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,
Yes in link I posted there is Azure Logic Apps - https://docs.microsoft.com/cs-cz/azure/logic-apps/logic-apps-workflow-definition-language
Flow is based on Azure Logic Apps, so there is possible to find description of functions that are used.
P.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response and the link!
🙂

Was this reply helpful? Yes No
hiteshn 61 on at

Like (0)

Report
Copy link

Link copied!

Hi,

There is not any such variable type that can be used for the dates in power automate, it can be stored in string type. Instead of this I used Compose action and just stored the date in value.
Using this original format type is reserved and does not need any conversions ahead.

To further work with updates such as adding, subtracting, etc. we can directly save these actions in compose variable or if already saved, 'Outputs' from compose action can be used.

Was this reply helpful? Yes No