Unanswered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No