So I have my process flow running, mostly incorporating different forms that populate result data into excel tables.
A form is submitted, parties are notified by email (the body of the email includes the previous forms results), then at the bottom of that email body, there is a link to another form that the receiver completes based on the information provided in the previous form. All results are then collected in excel tables.
I would like to create a flow for each form that triggers a week or so after the party receives the email only if the receiver does not move forward & submit the form linked inside the email.
Steps as follows:
1. A new form is submitted, triggers a flow that populates an excel table with the forms information.
2. An email is sent to parties involved in processing that information in the table, the email body contains the information submitted in the first form. The bottom of the email body has a link, that link is titled "Review the above data & submit the following form:"
3. The party (should) then click the link & submit the answers to that form.. which then populates more columns in the same row of tables. In the event that the party does not click the link, decides to do it later, and forgets about it, I would like to have a separate flow that for every 4 working days that the form does not get submitted, they get a reminder email to submit the form, but once they do submit that form, the flow would have to stop sending reminders.
I feel as though this is very possible to do, I am not familiar with how to use the variables & conditions actions.