I'm a newb, but learning!
Here's what I am trying to accomplish:
Students complete a form in which they are able to select to be contacted by a certain instructor. I would like the flow to automatically read the submission and rout the data to the selected instructor.
Here's what I've completed:
- I created a separate flow that updates data from the form into an Excel sheet with each submission.
- I created a table from this data for use in the new flow I am trying to create.
Here's what I need help with: (Please and Thank You!)
- I have assembled a flow for this
- Instead of using Recurrence with a fixed schedule, I'd like this flow to run when a new submission (form generated) has populated the Excel Sheet.
- There is a column in the Excel table called "Submission Time"
- My thought is that I would need to use Filter Query to filter by submission time. I was hoping this would assist in only generating emails to instructors when a new entry specified their name.
Here's a photo of my flow:
Here is the remaining detail of the other parts of the flow.
