Hi,
I have created a task to run whenever an email is received into a certain account. It creates a Todoist task for 2 days time however it includes a time even though the date format that I submit is only a date. The issue with this is that is always puts those tasks at the top of the day's task list, regardless of its priority.
Inputs: Due Date 5-Sep-19
Outputs: Task Due Date 2019-09-04T23:00:00.000Z
Interestingly, even though the output decreases the time by 1 hour, the task is still shown as midnight on 5 Sept.
Solved! Go to Solution.
Hi @Integral ,
I did a test on my side, although the Task Due Date displayed in Output contains time, the task created in Todoist does not contain time.
Expression reference:
formatDateTime(body('Add_to_time'),'yyyy-MM-dd')
Please try to refer to the following image to configure Flow.
Best Regards,
Hi @Integral
Can you share a screenshot of the flow?
While updating/ creating the task, are you directly passing the received time value? if so, you can modify that to a particular time format using the formatdatetime function:
formatDateTime(triggerBody()?['DateTimeReceived'],'dd/MM/yyyy')
this is considering that you are using the when an email arrives trigger.
If this differs, please post some screenshots of the flow so that we can better understand the issue and assist you with this.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Thanks for the reply That is pretty much what I am doing! However I have used "Get Future Time" to add on 2 days to the date the email is received and use the output from that:
formatDateTime(body('Get_future_time'),'d-MMM-yy')
It appears to be submitted correct but somehow is then changed (in my original message you can see the input to Todoist from the Flow and, what I assume is, the result from Todoist).
Hi @Integral
Can you try this:
Expression:
addDays(triggerBody()?['DateTimeReceived'],2)
Note that flow takes all input times from triggers in UTC. So you can use the convert action to convert the time to your timezone.
If you need the task due date to be 23:59:59 of the 2 days from the recieved time, you will have to configure the date in an expression as:
formatDateTime(addDays(triggerBody()?['DateTimeReceived'],2),'yyyy-MM-ddT23:59:59')
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @Integral ,
I did a test on my side, although the Task Due Date displayed in Output contains time, the task created in Todoist does not contain time.
Expression reference:
formatDateTime(body('Add_to_time'),'yyyy-MM-dd')
Please try to refer to the following image to configure Flow.
Best Regards,
Expression reference:
formatDateTime(body('Add_to_time'),'yyyy-MM-dd')
This sorted it, thank you!
It must have been Todoist adding a time when the date value was formatted my way (dd-MMM-yy) but formatting it your way has pushed it through just as a date.
As an aside, it took me 3-4 attempts to get the dynamic content to save correctly after I changed it. I would enter the new text, press update, press save then when I clicked on it there was either the original equation or only part of the new one there. Worth double checking as my first 2 tests simply used the old formula as I had not noticed.
Thanks for your help 😄
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
41 | |
40 | |
37 | |
34 | |
30 |
User | Count |
---|---|
52 | |
38 | |
36 | |
32 | |
24 |