Answered

Connecting MS Excel to MS todo

(0) Share

Report

Posted on by SimpL

Hi everyone,

I would like to make am excel file automation to MS todo. The excel file contains an email, date of creation, end date, and a few other columns with data.

What i would like to do, if the file gets updated online, then for every line the automation gets the 2 dates and makes a new todo entry, for ebery row that is inserted.

I tried to do this into outlook calendar but thats not a solution, at least i dont know where to go from there.

Does anyone know if this is possible? If yes then how?

Thank you in advance.

SimpL

All responses (3)

Answers (1)

powercorner 477 on at

Like (0)

Report

Re: Connecting MS Excel to MS todo

Hey @SimpL ,

you are very welcome!
I am glad I could help you.
If you have any problems in future (PowerApps or PowerAutomate) you can just reference me in you future posts 🙂
Just type @powercorner and add me to your question 🙂

With regards
Kevin
SimpL 4 on at

Like (0)

Report

Re: Connecting MS Excel to MS todo

Hy powercorner.

Thy for the answer, im currently trying to fine tune your suggestion. The main problem was i haven't created the excel with power automate, so it was not usable. But after I recreated it and did what you suggested I think its gonna work.
Thx again.
SimpL
Verified answer

powercorner 477 on at

Like (0)

Report

Re: Connecting MS Excel to MS todo

Hello @SimpL ,

I dont think that a solution like this build on excel is a good solution at all.
But you could store the excel in SharePoint or Onedrive and react on the change of the file.

You could then grab the Excel and read it line by line and create todo list items.

With regards
Kevin