cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mick_gibbons1
Helper I
Helper I

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @Mick_gibbons1 ,

 

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

 

I made a sample for you.

 

Create the following form.

vxiaochenmsft_0-1669775249839.png

 

 

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

vxiaochenmsft_1-1669775249840.png

 

 

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

vxiaochenmsft_2-1669775249841.png

 

 

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.

vxiaochenmsft_3-1669775249843.png

 

 

Save flow and run it.

vxiaochenmsft_4-1669775249844.png

 

vxiaochenmsft_5-1669775249844.png

 

Best Regards,

Wearsky

View solution in original post

4 REPLIES 4
v-xiaochen-msft
Community Support
Community Support

Hi @Mick_gibbons1 ,

 

I made a sample for you.

 

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

vxiaochenmsft_0-1669695853104.png

 

 

You can create a scheduled flow that runs daily.

vxiaochenmsft_1-1669695853106.png

 

 

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

vxiaochenmsft_2-1669695853108.png

 

 

Add a condition in Apply to each.

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

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

vxiaochenmsft_3-1669695853110.png

 

 

If yes, send an email.

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

vxiaochenmsft_4-1669695853112.png

 

 

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')

vxiaochenmsft_5-1669695853113.png

 

 

If yes, send an email.

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

vxiaochenmsft_6-1669695853115.png

Best Regards,

Wearsky

@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
Community Support
Community Support

Hi @Mick_gibbons1 ,

 

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

 

I made a sample for you.

 

Create the following form.

vxiaochenmsft_0-1669775249839.png

 

 

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

vxiaochenmsft_1-1669775249840.png

 

 

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

vxiaochenmsft_2-1669775249841.png

 

 

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.

vxiaochenmsft_3-1669775249843.png

 

 

Save flow and run it.

vxiaochenmsft_4-1669775249844.png

 

vxiaochenmsft_5-1669775249844.png

 

Best Regards,

Wearsky

@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

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,553)