Power Platform Community Forum Thread Details

Hi all,

Ive the following message when i try to save

The
input parameter(s) of operation 'Filter_array' contains invalid
expression(s). Fix invalid expression(s) for the input parameter(s) of
operation 'Filter_array'.

what's wrong with that expression ?

@and(
@and(
@greaterOrEquals(formatDateTime(items('Apply_to_each')?['start']?['dateTime'], 'HH:mm'), '09:30'),
@lessOrEquals(formatDateTime(items('Apply_to_each')?['start']?['dateTime'], 'HH:mm'), '19:00')
),
@or(
@equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 1), // Lundi
@equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 2), // Mardi
@equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 3), // Mercredi
@equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 4), // Jeudi
@equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 5) // Vendredi
)
)

Many thanks!

Categories:

Building flows

You don't show your flow, so I don't know where you are trying to use your expression, but I see a number of issues. You would not use @ in an expression in Power Automate unless it is a trigger condition, and even then, the @ would be at the start of the expression.

As far as I know, comments are not allowed in Power Automate expressions, so all of those are invalid. I have cleaned it up as much as I can, but I have not tested this and am not sure it will work. This will give you a better idea of what it needs to look like to work:

and(greaterOrEquals(formatDateTime(items('Apply_to_each')?['start']?['dateTime'], 'HH:mm'), '09:30'), lessOrEquals(formatDateTime(items('Apply_to_each')?['start']?['dateTime'], 'HH:mm'), '19:00'), or(equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 1), equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 2), equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 3), equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 4), equals(dayOfWeek(items('Apply_to_each')?['start']?['dateTime']), 5)))

Maybe someone else will see how I have formatted it and can offer additional advice if it does not work.