Flow references calculated column in excel, detects values as string, not number/integer

Robertson, Jennifer 1 Reputation point
2020-08-26T21:49:39.933+00:00

I have a flow which is attached to an excel spreadsheet in a teams environment. I want to create a flow so that on a schedule, all those people with expiring training dates are emailed. I know that there is no function in flow similar to datediff, therefore I have created two extra columns to do the calculations. Each column shows me the difference in dates in days. Whole number.

The flow is created to assess each row and send emails to those where the datediff is less than 1.

However when I run the flow I get errors:

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
38,796 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-08-26T22:00:34.277+00:00

    Power automate is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.