web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Combine conditions on ...

Power Automate

Unanswered

Combine conditions on filter array

(0) Share

Report

Report

Posted on by ezequiel

Hi

I'm trying to combine two AND on the following:

@And(equals(item()?['_me_areaoptionset_label'], 'United States'),greater(item()?['msevtmgt_eventstartdate'],utcnow())

but I'm getting the following error:

There is an unterminated string literal at position 28 in 'msevtmgt_eventstartdate gt ''.

Can you help me to understand what is going wrong?

Thanks

Ezequiel

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Expiscornovus 33,183 Most Valuable Professional on at

Like (0)

Report
Hi @ezequiel,

It looks like you are missing a closing ). And I would also say you probably needs some formatting in your utcNow funciton as well.

Can you try this instead:

@and(equals(item()?['_me_areaoptionset_label'], 'United States'),greater(item()?['msevtmgt_eventstartdate'], utcNow('yyyy-MM-dd')))

Note: you might need to change the formatting to the formatting you are using in that eventstartdate though.

Was this reply helpful? Yes No
ezequiel on at

Like (0)

Report

Thanks for the reply. I tested it with your suggestion, but I'm still getting the error
"There is an unterminated string literal at position 28 in 'msevtmgt_eventstartdate gt ''."

the format of the eventstartdate is correct as yyyy-MM-dd

Any suggestion?

Thanks

Ezequiel

Was this reply helpful? Yes No
Expiscornovus 33,183 Most Valuable Professional on at

Like (0)

Report

Hi @ezequiel,

Can you share a couple of screenshots of your flow setup?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @ezequiel :

Maybe you could try:

@And( equals(item()?['_me_areaoptionset_label'], 'United States'), greater(formatDateTime(item()?['msevtmgt_eventstartdate']),utcnow()) )

If this formula not work,could you please tell me:

What is msevtmgt_eventstartdate's data type?

Could you provide a demo of the data source?

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation