Hi @Pavan G ,
Would you please try formatDateTime(body('Get_entities')?['value'][0]?['Date'], 'yyyy-MM-dd')
instead of formatDateTime('body('Get_entities')['value'][0]['Date']','yyyy-MM-dd')
.
Thanks!
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Experts,
I have a requirement in LogicApp where I need to compare the date and proceed to the next step only if it is true.
Compare date from the Source XML which is picked from ASB against the date is which is picked from the Azure table storage.
Date format from XML: YYYY-MM-DD
Date format from Azure Table STorage: MM/DD/YYYY
For testing the condition block I set the date format from XML to MM/DD/YYYY and used the dynamic expression like
formatDateTime('body('Get_entities')['value'][0]['Date']','yyyy-MM-dd')
Logic App is throwing the error as below.
My case is similar to: https://stackoverflow.com/questions/54806424/how-to-check-the-greater-than-in-condition-block-in-azure-logic-app. But there is no answer for this query.
Any help would be of great help.
Regards,
Pavan
Hi @Pavan G ,
Would you please try formatDateTime(body('Get_entities')?['value'][0]?['Date'], 'yyyy-MM-dd')
instead of formatDateTime('body('Get_entities')['value'][0]['Date']','yyyy-MM-dd')
.
Thanks!