
Announcements
Hi All,
please i want to create a work flow that will filter responses from a form and send email to specific individuals at 5pm based on a choice field i named departments.
can some one guide me please?
thank you.
Hi!
You can follow a two-flows strategy...
1.- First flow based on this template to store all responses in a sharepoint list
2.- Second flow with a Schedule trigger, next a 'Get items' action block to read all elements from your sharepoint list, then do whatever action you need based on the conditions you set
...or, identify where the Forms Excel is stored, then design a single scheduled flow, next a 'List rows from a table' action block to read all rows from you Excel file, then do whatever action you need based on the conditions you set
The Forms Excel location depends on how you set up your Forms: you can assign it to your account (so it is stored in your OneDrive / OneDrive4Business), or link it to a TEams (so it is stored in the TEams related Sharepoint), or...
Hope this helps