Microsoft Flow Todoist



Microsoft powerapps and logic flows

Microsoft Flow is a free tool that can automate some routine operations, like automatically adding calendar events, forwarding emails, and so on. I have been using it for many years now, since it just launched. And Todoist connector is one of my most used building blocks.

Todoist Windows 10 Download

  1. Todoist is an online task management app and todo list. With Todoist, users can organize, schedule, maintain and prioritize personal tasks. See documentation.
  2. By Microsoft When you get an email marked as important in your Outlook.com inbox, a task will be created in Todoist, with a due date of the end of the day.
Todoist windows 10 download

Unfortunately it recently stopped working. Todoist developers deprecated legacy API and Microsoft didn’t update the connector in time. Now all the jobs are failing with this error:

Create a new task in Todoist from a Microsoft Teams message. Work less, do more. Connect your favorite apps to automate repetitive tasks.

Powerapps And Flow

Action 'Create_a_task' failed
Error Details: The response is not in a JSON format.

Fix: no, ETA: no

Microsoft Flow Todoist Project Id

There is no fix or a workaround that I am aware of. I have reported the issue here: https://powerusers.microsoft.com/t5/I-Found-A-Bug/Todoist-connector-no-longer-working-due-to-the-API-endpoint/m-p/355721#M5216

Todoist For Outlook

It was acknowledged, but there is no information whether the fix is in progress or when it should be deployed.

Do you use Microsoft Flow? What is your workflow setup? Please share it in comments.

At the company where I work we regularly have knowledge transfer sessions called Brown Bag Lunches (BBLs) which I think is a great way to share and give back. I am in charge of scheduling these.

I wanted automate the process for planning these sessions and give my colleagues a way to submit suggestions for content. I started by setting a simple Microsoft Form for them to add suggestions

Sorry about the Swedish 🙂

Microsoft has a page for looking at the results of the form submissions which I could have used to get the subjects and plan them manually… but where is the fun in that :-). My solution was to add a flow that is triggered every time a form is submitted which adds it to an excel spreadsheet and adds a todo task in my todo list of choice Todoist.

The result from Forms is in a JSON format so the first thing we need to do is to parse the JSON message.

Todoist for outlook

The parsing of the JSON also means that we can use the content as dynamic content and add it without having to write an expression… the No-Code way. The JSON message also only contains the response id so we will have to use a “Get response details” block to get the actual information of the form.

TodoistMicrosoft flow todoist

The reason we are extracting the information is to put it in the Excel file… The response only contains the submitting users email adress so to get the excel file to look a bit nicer I use the Get User Profile block to look up the users real name from the Azure AD/SharePoint. This is a really cool block since it can get a whole lot of cool info from you organization such at a users manager etc.

Todoist Download

Finally I add a line to an excel file and put a reminder i my todo list

I would really continue building this logic to automate the planning even further… I might have to revisit this in a later post 🙂

Download Todoist Desktop

Have a nice weekend

Microsoft Powerapps And Logic Flows

Johan