Hello everyone
I cant change the format of Response date (from approval flow), 2017-12-13T10:25:46.1068622Z. I want to convert it like I did with utcnow, to look like this: 12/13/2017 12:25:46 PM. Any ideas?
Much appreciated!
Solved! Go to Solution.
Hi Doru,
Please try to use Workflow definition language formatDateTime to format the datetime.
More details please check it at here:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language
For your scenario, you may try to create a flow and configure the code to format the datetime using the following function:
formatDateTime(body('Start_an_approval')?['responseDate'],'MM/dd/yyyy hh:mm:ss')
Please have a try with it.
Best regards,
Mabel Mao
Hi Doru,
Please try to use Workflow definition language formatDateTime to format the datetime.
More details please check it at here:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language
For your scenario, you may try to create a flow and configure the code to format the datetime using the following function:
formatDateTime(body('Start_an_approval')?['responseDate'],'MM/dd/yyyy hh:mm:ss')
Please have a try with it.
Best regards,
Mabel Mao
Finally I understand 🙂 so instead of Response date, I must use Output and at multiple Approvals, in your formula must change to Start an approval 2,3,etc. so i get different Outputs
Cheers! Thanks alot!
User | Count |
---|---|
25 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
48 | |
29 | |
28 | |
25 | |
23 |