web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add a row to table whe...
Power Automate
Unanswered

Add a row to table when task is 100% and zipping file contents from sharepoint

(0) ShareShare
ReportReport
Posted on by 33

I am currently building a flow that does/needs to do the following:

- When a form is submitted create a task in planner

- Update the planner task details

- Have a condition that when the task is completed, create a row in an Excel table with all data

- If certain form options were selected, send specific emails once the task is completed

- Zip up or copy the files in a sharepoint link and place them in an archive

 

flow-pic-2.png

flow-pic-3.png
Where I am getting stuck is that the "Do Until" Seems to trigger even when the "Percentage Complete" isn't 100. Am I doing this wrong?


To zip/archive those files I have a link that was submitted in the form to where they are, but have no idea how to do that.


This all needs to be in a single flow as I need to have the dynamic content from the form submission available in at the end of the flow for the excel row insert and emails.


Any help would be appreciated 🙂

Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at

    Hi!

    I would avoid a single flow approach and try with a two flow instead.

    So your new first flow keeps the same trigger as the one you are currently using.

    - When a form is submitted

    - create a task in planner

    - Update the planner task details

    And, your new second flow should be triggered 'When a task is completed'

    https://docs.microsoft.com/es-es/connectors/planner/#when-a-task-is-completed

    - when the task is completed

    - create a row in an Excel table with all data

    - If certain form options were selected, send specific emails once the task is completed

    - Zip up or copy the files in a sharepoint link and place them in an archive

     

    This way you can avoid Delay, Do Until etc.

    Hope this saves your day

  • James_Anderson Profile Picture
    33 on at

    Hi, unfortunately I can't split these into two flows as I mentioned in the post. I need to be able to use the dynamic content to populate parts of the flow right at the end and if I split it, there is no way to do this.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard