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

(0) Share

Report

Posted on by James_Anderson

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

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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

efialttes 14,756 on at

Like (0)

Report

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

Was this reply helpful? Yes No
James_Anderson 33 on at

Like (0)

Report

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.

Was this reply helpful? Yes No