Unanswered

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

(0) Share

Report

Posted on by MicrosoftAdmin

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')}"

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

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (1)

Report
@MicrosoftAdmin

Please try putting single quote around the formatdatetime

Was this reply helpful? Yes No
Fubar 8,338 Super User 2025 Season 2 on at

Like (1)

Report

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)

Was this reply helpful? Yes No
MicrosoftAdmin 74 on at

Like (0)

Report

Yaass Queen!

Worked wonders, thanks so much 👍

Was this reply helpful? Yes No