Power Automate

Set variable condition

(1) Share

Report

Posted on by hpayne1993

49 Season of Giving Solutions 2025

Hi there,

Struggling to get my expression to work for this one. Any ideas?

Essentially, I have a variable 'contact type' which stores a text value and a compose which counts the number of rows from a list rows function.

If the value of the compose action is 1 or more, and contact type DOES NOT equal student OR teacher I need the value to return as true

if(
    and(
        equals(outputs('Compose_-_ABC_coms_memberships'), 1),
        or(
            not(contains(variables('contact type'), 'teacher')),
           not(contains(variables('contact type'), 'student'))
        )
    ),
    true,
    false
)

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

try below :

if(
and(
greaterOrEquals(outputs('Compose_-_ABC_coms_memberships'), 1),
not(
or(
contains(toLower(variables('contact type')), 'teacher'),
contains(toLower(variables('contact type')), 'student')
)
)
),
true,
false
)

Was this reply helpful? Yes No
hpayne1993 49 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@11manish thankyou! I'm now getting this error

Unable to process template language expressions in action 'Set_variable_-_eligible_for_PLG_rate' inputs at line '0' and column '0': 'The template language function 'greaterOrEquals' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Array'.'.

I've converted the compose action to integer but this hasn't helped. any ideas?

Was this reply helpful? Yes No
11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

greaterOrEquals() received an array instead of a number

We can fix it by use of length() or empty() to evaluate the array

Can you try below :

and(
greaterOrEquals(
length(outputs('Compose_-_ABC_coms_memberships')),
1
),
not(
or(
contains(toLower(variables('contact type')), 'teacher'),
contains(toLower(variables('contact type')), 'student')
)
)
)

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,204 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hii @hpayne1993,

Try this:

Use greaterOrEquals(outputs('Compose_-_ABC_coms_memberships'), 1) this instead.
The fix is to swap or for and inside your not-contains checks.

if(
and(
greaterOrEquals(outputs('Compose_-_ABC_coms_memberships'), 1),
and(
not(contains(variables('contact type'), 'teacher')),
not(contains(variables('contact type'), 'student'))
)
),
true,
false
)

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No
hpayne1993 49 Season of Giving Solutions 2025 on at

Like
a
(1)

Report
Copy link

Link copied!

@11manish thankyou

I am not receining an error anymore.

Although it is now returning true when compose is 0. It should only be true when it is 1 or more

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @hpayne1993,

You can try bit optimized one here:

And( CountRows(outputs('Compose_-_ABC_coms_memberships')) >= 1, !Or( startsWith(toLower(variables('contact type')), "teacher"), startsWith(toLower(variables('contact type')), "student") ) )

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No