Unanswered

Create a new task in planner from every new row in an excel table

(0) Share

Report

Posted on by Community Power Pla...

I'm having problem to create tasks in Planner from an Excel sheet. I would like to create tasks when there is more data on every row in excel. Which command to use this flow?

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Create a new task in planner from every new row in an excel table

Do you want to create a new task when a new row is added in an excel file?
>> Yes, we have sale transaction (1 row = 1 transaction), so when we have new transaction we will add new row in excel.
Could you please share a bit more about your scenario?
>> When a new entry (data) is added to the excel sheet, Always create only new data task

PS. Previously, we used the Zapier to create task like this.
v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Create a new task in planner from every new row in an excel table

Hi @Anonymous，

Do you want to create a new task when a new row is added in an excel file?

Could you please share a bit more about your scenario?

Currently, there is no OOTB new row added trigger for Excel table, so we could not create a new task based on the new added row from the excel file.

As a workaround, I will suggest you add a field in your excel file to save the task id so that we could create a new task based on that if there is a task id existing in the excel file. If there is no task id in one row, you could create a new task.