You’re offline. This is a read only version of the page.
Announcements
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
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,
Share
Report
All responses (
Answers (
522
