Create planner tasks from Excel, record task ID to check for new rows only

Like (0) Share

Report

Posted on 13 Jun 2022 23:04:05 by DCDC

I have an excel sheet that is regularly updated. I'd like a planner task created for every time a new row is added.

1. Is there a way to get a record of the Task ID and insert it back into the Excel sheet? Or how do you track the task ID? This leads to my second question.

2. I want to only create planner tasks for NEW rows of information.

The flow I created is currently set to trigger manually and adds every row of the excel sheet every time I run it thus creating duplicates.

Thanks

All responses (1)

Answers (1)

Verified answer

v-jefferni on 16 Jun 2022 at 09:25:18

Like (0)

Report

Re: Create planner tasks from Excel, record task ID to check for new rows only

Hi @DCDC ,

Since there is no trigger for new rows of Excel table, you can only use a button or concurrent trigger to list rows of the table.

So, for your scenario, you can list rows that are blank in Task ID column, apply to each row to create a task and update the same row based on the key column/value:

You can select the created task id in dynamic contents:

Best regards,