cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Getting each excel row only once

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Getting each excel row only once

@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:

  1.  Use a recurrence trigger to periodically run the Flow (hourly? daily?)
  2. 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
  3. Loop through the rows returned
  4. Create a planner task based on each row of data
  5. 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.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Getting each excel row only once

@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:

  1.  Use a recurrence trigger to periodically run the Flow (hourly? daily?)
  2. 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
  3. Loop through the rows returned
  4. Create a planner task based on each row of data
  5. 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.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,895)