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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 506 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard