Share
ReportThere 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)?
You’re offline. This is a read only version of the page.
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)?
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.
Thanks for the response and the link!
🙂
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.
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!
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.
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
All responses (
Answers (