Have Google calendar events created whenever you add a Todoist item. You will need to select a project and calendar to sync. Work less, do more. Connect your favorite apps to automate repetitive tasks. Explore Microsoft Power Automate. See how it works. Check out a quick video about Microsoft Power Automate. Watch it now Build. Add new OneNote pages as Todoist tasks. When a new OneNote page is created, get a task added to a Todoist project as well. Create Todoist task for Trello card and send notification. Explore Microsoft Power Automate. See how it works. Check out a quick video about Microsoft Power Automate. Planner task to Todoist task. Explore Microsoft Power Automate. See how it works. Check out a quick video about Microsoft Power Automate. Spend more time on what matters and less on task management. By integrating ToDoist with other online services, you can automate a lot of the work it takes to maintain your busy life schedule.

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 Power Automate

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.

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.

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.

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

Power Automate Todoist

Power Automate Todoist Login

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

Have a nice weekend

Johan

Never export a CSV again

Power Automate Todoist Download

ToDoist connector & integration. We consolidate your ToDoist data, so you can automate data into PowerBI & Excel & Google Sheets

Automate your ToDoist reporting in 3 easy steps

A world-class technology platform & real people to listen and guide you to 100% automated reporting

Ready to see us in action? We’ll show you how to apply ToDoist Consolidated Reporting solutions to your business.

About ToDoist

Todoist is a project management application for personal and professional productivity. It allows users to manage their tasks from a smartphone, tablet or computer. The app is free, though additional features to enable collaboration are available in a paid version. Todoist was created in 2007 by startup Doist. As of June 2014, it has 2 million users.