Send an email when due date is tomorrow

[gardnerlhwrc]

Hi All, Hoping someone can help me understand why im getting a certain error. 

Very simple request, trying to get the flow to send me a trigger when the due date is tomorrow...only issue is Monday where I want it to send on Friday but forget that for now....if I can't figure that out I will just make a separate flow. 

BUT

I'm getting an error which I don't understand why its happening. 

Here is the current set up. 

Left Condition 

 formatDateTime(item()['PermiteEndDate'],'dd-MM-yyyy')     (understand the spelling error but looking at SP list thats how it's listed in URL)

Right

addDays(utcNow(),1,'dd-MM-yyyy')

Last part of the flow is just send an email when condition above is true. 

I'm getting this error and dont understand why. 

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language expression ' formatDateTime(item()['PermiteEndDate'],'dd-MM-yyyy')' cannot be evaluated because property 'PermiteEndDate' doesn't exist, available properties are '@odata.etag, ItemInternalId, ID, Title, Description, SubmittedbyName, SubmittedbyEmail, AssignedName, SubmittedDate, Status, Priority, ModifiedDate, Cost, OData__x0033_MonthCheck, Modified, Created, Author, Author#Claims, Editor, Editor#Claims, SubmittedDay, SubmittedMonth, SubmittedYear, CompletedDay, CompletedMonth, CompletedYear, {Identifier}, {IsFolder}, {Thumbnail}, {Link}, {Name}, {FilenameWithExtension}, {Path}, {FullPath}, {HasAttachments}, {VersionNumber}'. Please see https://aka.ms/logicexpressions for usage details.'.

Which to me basically is saying that the system doesn't see my column PermiteEndDate

Am I going crazy?

[gardnerlhwrc]

Stand down....Seems even though the flow throws an Error it still works. 

If someone could tell me if im on the right path regarding email being triggered on Friday in the due date is Monday. 

Can use another flow but slightly different condition? 

Right 

formatDateTime(item()['PermiteEndDate'],'dd-MM-yyyy')

Left

addDays(utcNow(),3,'dd-MM-yyyy')

AND

dayofweek == 1

If true 

Send email

False

Nothing

[v-qiaqi-msft · Accepted solution]

Hi @gardnerlhwrc,

I have seen that you have a duplicated thread here.

Since you have resolved this, I will mark here and close this case.

Thanks for your cooperation.