I have created a flow that runs successfully, however the condition is never met and no documents are ever deleted, can someone point me to where I am going wrong please?
The condition is
utcNow('yyyymmdd') is greater than formatDateTime(addDays(item)?['Created'],2),'yyyymmdd')
The documents have been created for more than 5 days so in theory should be deleted?
Any help appreciated.
Thank you for the support, really appreciated. The workflow failed this time with the following error message:
ActionFailed An action failed. No dependant actions succeeded
Condition set to:
TThis means that the condition wasn't satisfied, can u add each expression to a compose data operation to be able to see the values of each on the workflow run
Apologies, I am new to Flows in this format, I added a compose data operation the first expression returned 2020-08-11
The second expression returned 2020-08-08 as the documents were created on the 06/08/2020 this would seem right?
In the Delete file action it warns "NotFound"
YYes for the first compose please add formatdatetime(utcnow(), 'yyyy-MM-dd ')
And another compose data operation and in the expression add
Run the flow, then open the flow run and examine the outputs of the 2 compose Data operations., may be you need to convert the second date to Utc
Hi, I just edited my last post once I realised what you had asked, I got the following returns from the expressions:
Expression 1 returned 2020-08-11
Expression 2 returned 2020-08-08
Documents were created on the 06/08/2020 so the second expression is correctly adding 2 days to the created date so all should be well?
Thank you for the help
Yes the expressions looks good, can u use the outputs of the compose data operation in the condition expression instead and if you can share a screenshot this will be great.
Can u try to use the convert time zone action to convert from UTC to your time zone and the use the output in the left side of your condition expression
Hi, I am lost! Can you give me an example please, I have searched Google and cannot work out what it is you are asking me to do?
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks