Power Platform Community Forum Thread Details

I'm trying to build a flow from the "Create Planner tasks from Excel spreadsheet on a recurring basis" template, but I only want each row of my spreadsheet to get made into a planner task once. I tested the flow with my own spreadsheet, and it will create a task from the rows in excel, but it will repeat the rows that have already been made into tasks. What should I do so that each new row added to the excel will get made into a planner task one time. Also, is there an automated trigger for a new row added to an excel spreadsheet, or has that not been added yet?

Categories:

Building flows

@scartwri

You probably need to add an additional column to your table that indicates if a planner task has been created as yet. If you do so, here is how you can approach this issue:

Use a recurrence trigger to periodically run the Flow (hourly? daily?)
Use a List Rows Present in a Table action
1. Use a filter query that only returns rows where a planner task has not been created as indicated by the additional column you added
Loop through the rows returned
Create a planner task based on each row of data
Update the row of data to indicate that a task has been created - update the column that you added
1. You will use an Update a Row action

There is not yet a trigger that fires when a row has been added to a table.

If you need an example, please let me know.