Collecting a date in MS forms and using as Schedule action in Automate Flow

[Mick_gibbons1]

Evening all,

I am looking for some help with a flow. I have an MS form that individuals fill out, in that form they select a date they are leaving in the future.

I would like to run a flow that looks at that date, then 3 weeks before emails a reminder to a work colleague. 

Then at 2 months and 4 months (from leaving date) email the person that filled out the form to ask them if they need anything 

I really appreciate your help

Mick

[v-xiaochen-msft]

Hi @Mick_gibbons1 ,

I made a sample for you.

If you have a list for saving data from the form, like this:

You can create a scheduled flow that runs daily.

Run once a day to get the items in the list.

Add a condition in Apply to each.

subtractFromTime(items('Apply_to_each')?['LeaveDate'],3,'Week','yyyy-MM-dd')

formatDateTime(utcNow(),'yyyy-MM-dd')

If yes, send an email.

Items(‘Apply_to_each’)?[‘Title’]

If no, add another condition.

addToTime(items('Apply_to_each')?['LeaveDate'],2,'Month','yyyy-MM-dd')

addToTime(items('Apply_to_each')?['LeaveDate'],4,'Month','yyyy-MM-dd')

formatDateTime(utcNow(),'yyyy-MM-dd')

If yes, send an email.

Items(‘Apply_to_each’)?[‘Title’]

Best Regards,

Wearsky

[Mick_gibbons1]

@v-xiaochen-msft 

Thank you so much.

The form writes to Excel, is there a way to do it off that? or do i need a flow to populate sharepoint list?

[v-xiaochen-msft · Accepted solution]

Hi @Mick_gibbons1 ,

You can create another flow to save form data in SharePoint.

I made a sample for you.

Create the following form.

Create a list in SharePoint that corresponds to the questions in the column and form.

If there is data saved in Excel before, you can create a list with Excel data.

Create a flow that fires when a form is submitted. Get the data in the form and create a new item in the list based on the data.

Save flow and run it.

Best Regards,

Wearsky

[Mick_gibbons1]

@v-xiaochen-msft this is excellent. Will it create a list of everything answered? like name, address etc?

Thank you so much, I will be giving this ago