Unable to process template language for deleting old O365 mails

[FlowUser2487]

Dear all,

I'm relatively new to power apps and have a problem I can't solve.

I want to delete mails in a specific folder that are older than X days. So far so fine, I followed the instructions of a guide and set everything up. But while testing it I always get an error:

Spoiler

Unable to process template language expressions for action 'Condition_2' at line '1' and column '15804': 'The template language expression 'formatDateTime(item()['DateTimeReceived'],'yyyy-MM-dd')' cannot be evaluated because property 'DateTimeReceived' doesn't exist, available properties are 'id, receivedDateTime, hasAttachments, internetMessageId, subject, bodyPreview, importance, conversationId, isRead, isHtml, from, toRecipients, attachments, body'. Please see https://aka.ms/logicexpressions for usage details.'.

The condition is setup as following:

if

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

is less than

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

Do you know how I can fix the error and get the flow working? (as recommended in some other articles I already tried to save it with a different name and to re-submit/re-deploy it)

[ScottShearer · Accepted solution]

@FlowUser2487 

Try changing DateTimeReceived in your expression to receivedDateTime

[FlowUser2487]

Dear @ScottShearer 

Thank you, that solves the error message. Now the flow runs without errors.

But it still doesn't seem to run properly.

The deletion command results in

"ActionBranchingConditionNotSatisfied. The execution of template action 'Delete_email_(V2)_2' skipped: the branching condition for this action is not satisfied."

Even though there are the full 25 max items that should get deleted. Any tips for me?