Unanswered

How to initialize Date Type variable

(2) Share

Report

Posted on by Community Power Pla...

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

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

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

🙂
P.

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

Like (0)

Report

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

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... on at

Like (0)

Report

Thanks for the response and the link!
🙂

Was this reply helpful? Yes No
hiteshn 61 on at

Like (0)

Report

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