Email notification for overdue certificate date in excel sheet

(0) Share

Report

Posted on by Ama19x89

Hi All,

I need your help with below topic:

I have a table in Excel like this:

and I want by using Power Automate recieved emails, about overdue Expiration Date. I used such a flow:

A condition step has such details:

items('Foreach')?['ExpirationDate'] is less than utcNow()

Unfortunatelly I recieved a message that my test is faild due to such a message:

InvalidTemplate

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

Can Anybody please help me to resolve this case?

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (0)

VictorIvanidze 13,073 on at

Like (0)

Report
Add another expression:
empty(items('Foreach')?['ExpirationDate']) is equal to false

Was this reply helpful? Yes No
Ama19x89 12 on at

Like (0)

Report

Thank you! but right now there is another error/condition not met:

Email step got this info after test conducting:
ActionBranchingConditionNotSatisfied
The execution of template action 'Send_an_email' skipped: the branching condition for this action is not satisfied.

So I didn't recieved any mail 😞 Could you help to fix it?

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Investigate why the condition returns false.

Was this reply helpful? Yes No
Ama19x89 12 on at

Like (0)

Report

A table looks like here:
Maybe I have something wrong with format date and Power Automate doesn't recognize format date in Excel?

In List rows present in a table STEP I didn't add any additional filter query to transiotion my format date, maybe this is a solution?

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Use formatDateTime() expression yyyy-MM-dd for both dates.

Was this reply helpful? Yes No
Ama19x89 12 on at

Like (0)

Report

Could you specify where and what exacly should I write in expresion? Because right now there is a failure and it doesn't work:

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

In the condition.

Was this reply helpful? Yes No
Ama19x89 12 on at

Like (0)

Report

Like this? it is still doesn't work:

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Before the condition create 2 compose actions for both formatted dates. Show their outputs.

Was this reply helpful? Yes No
Ama19x89 12 on at

Like (0)

Report

In compose1 ( inputs": "@formatDateTime(items('Foreach')?['ExpirationDate'],'yyyy-MM-dd') )
I got failure:
InvalidTemplate
Unable to process template language expressions in action 'Compose1' inputs at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Was this reply helpful? Yes No