Skip to main content
Community site session details

Community site session details

Session Id : x1gXVsk714mrXsp9Jz46MU
Power Automate - Building Flows
Answered

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

Like (1) ShareShare
ReportReport
Posted on 15 Aug 2023 20:04:46 by 16

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.pngScreenshot 2023-08-15 at 4.02.22 PM.png

  • cburket Profile Picture
    16 on 15 Aug 2023 at 23:18:21
    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 Profile Picture
    14,058 Super User 2025 Season 2 on 15 Aug 2023 at 22:48:27
    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!

     

    trice602_1-1692139685395.png

     

     

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

     

  • cburket Profile Picture
    16 on 15 Aug 2023 at 22:43:24
    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:

    Screenshot 2023-08-15 at 6.40.48 PM.png

  • trice602 Profile Picture
    14,058 Super User 2025 Season 2 on 15 Aug 2023 at 20:15:51
    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 Profile Picture
    14,058 Super User 2025 Season 2 on 15 Aug 2023 at 20:13:44
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2