web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Flow with OData to Ema...
Power Apps
Unanswered

Flow with OData to Email When Date Column on PowerApps Table Passes Today

(0) ShareShare
ReportReport
Posted on by 74

Hi there, thanks for viewing this query and for any answers you may provide. 

 

My PowerApp has a table [Projects] with a column [msdyn_finish] of completion dates. I would like to have a flow to be alerted 1 week before the completion date.

 

Allow me to show what I have so far. See screenshot:
(for clarity, the "filter rows" expression is "msdyn_finish lt @{formatDateTime(utcNow(),'dd/MM/yyyy')}"

MicrosoftAdmin_1-1653661928409.png

 

I'm getting a very unhelpful error: "An identifier was expected at position 16." see screenshot:

MicrosoftAdmin_2-1653662102015.png

 

When i select Show raw inputs, I get the following (the scrollbars on the resulting screen also shakes implying something is really wrong):

MicrosoftAdmin_3-1653662170716.png

 

 

I have the same question (0)
  • Mira Ghaly Profile Picture
    11,413 Moderator on at

    @MicrosoftAdmin 

    • Please try putting single quote around the formatdatetime

     

     

     

  • Fubar Profile Picture
    8,338 Super User 2025 Season 2 on at

    Also think the Filter part of the query when its generated is expecting reverse date yyyy-mm-dd  try hard code a value in the Filter as per https://docs.microsoft.com/en-us/power-automate/dataverse/list-rows#advanced-options and test run it to see if it still errors (that will tell you if its a date format issue or possibly a null date issue)

  • MicrosoftAdmin Profile Picture
    74 on at

    Yaass Queen!

     

    Worked wonders, thanks so much 👍

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard