How to initialize Date Type variable

[Anonymous]

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)?

[vecerpa · Accepted solution]

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.

[vecerpa]

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

🙂

P.

[Anonymous]

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!

[vecerpa · Accepted solution]

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.

[Anonymous]

Thanks for the response and the link!

🙂

[hiteshn]

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.