Help needed - Want flow to run each time there is a new entry that matches today's date in my Excel Sheet

(1) Share

Report

Posted on by cburket

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:

Screenshot 2023-08-15 at 3.13.28 PM.png

Here is the remaining detail of the other parts of the flow.

Screenshot 2023-08-15 at 4.02.06 PM.png

All responses (5)

Answers (1)

cburket 16 on at

Like (1)

Report

Re: Help needed - Want flow to run each time there is a new entry that matches today's date in my Excel Sheet

Amazing! Wow. Thank you so much, Tom. You are a ninja 😀
Verified answer

trice602 13,773 Super User 2025 Season 1 on at

Like (1)

Report

Re: Help needed - Want flow to run each time there is a new entry that matches today's date in my Excel Sheet

Hi @cburket ,

It looks like you typed in the expression in the compose, it has to be an expression. Delete the content there, then exit the compose and back in, next click on the "fx" that will appear in the right of the field in the compose. That's where you write expressions. You got this!

Please mark as a solution ✅ and/or give me a thumbs up 👍🏽 for replying and volunteering my time! 🎗️ Always glad to help! Tom ⭐⭐⭐⭐⭐
cburket 16 on at

Like (1)

Report

Re: Help needed - Want flow to run each time there is a new entry that matches today's date in my Excel Sheet

Thank you so much Tom! I really appreciate your time. After revision, the run failed. Please bear with me...

I am getting this error:
Syntax error at position 38 in 'Date eq 'formatDateTime(UTCNow(),'yyyy-MM-dd')''.
inner exception: Syntax error at position 38 in 'Date eq 'formatDateTime(UTCNow(),'yyyy-MM-dd')''.
clientRequestId: 2b55077c-68c3-4466-af44-7fb178e3534f

Here is the revised flow order:
trice602 13,773 Super User 2025 Season 1 on at

Like (0)

Report

Re: Help needed - Want flow to run each time there is a new entry that matches today's date in my Excel Sheet

To make it dynamic add a compose before:

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

Then, for your OData filter Date eq 'output(Compose)' //select the dynamic content of compose, put inside ' '.

Please mark as a solution ✅and/or give me a thumbs up 👍🏽for replying and volunteering my time! 🎗️ Always glad to help! Tom ⭐⭐⭐⭐⭐
trice602 13,773 Super User 2025 Season 1 on at

Like (0)

Report

Re: Help needed - Want flow to run each time there is a new entry that matches today's date in my Excel Sheet

Hi @cburket ,

Please use this in your OData filter:

Date eq '2023-08-15'

Please mark as a solution ✅ and/or give me a thumbs up 👍🏽 for replying and volunteering my time! 🎗️ Always glad to help! Tom ⭐⭐⭐⭐⭐