Power Platform Community Forum Thread Details

This is my flow

when a row is added to a table (Table1) then check Status = Pending, if Pending send email alert. (frequency is run once a week)

Below is the error encountered:

Action 'Condition' failed: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'contains' expects parameters of matching types: a dictionary and a key (string), an array and a value (object), or a string and a substring. The provided types 'String' and 'Boolean' are incompatible. Please see https://aka.ms/logicexpressions#contains for usage details.'.

This is the condition

In the sharepoint there is an excel file column name Status

So if the status in the cell is Pending

then the actions continue - to send email alert.

In the Status column O (after column N), it has auto formula:

example:

=IF(N27<>"","Closed","Pending")

The format for column O is text.

Please advise what went wrong with the condition, everything looks ok to me.

Categories:

Building flows

Hi @mementoQ,

The error is happening because you are trying to compare two values of different type under a condition: in this case, the value from your Excel column (a text, which can be either "Closed" or "Pending") and the outputs of your contains formula (a boolean, which can be either true or false).

If I understood correctly, you want the condition to be true if the Status column from your Excel table is equal to pending. To achieve it, you can simply change the dropdown to is equal to and the right-side input to Pending: