startswith works but contains does not

(0) Share

Report

Posted on by Berrismfb

Hello community,

I have a strange issues. I have a simple flow that asks for a piece of text then checks is a field in a list contains the text. If I use the startswith expression it works like a charm but I change the word "startswith" with the word "contains" and I get an error saying expression is invalid ?

Help Please

startswith(Quote_x0020__x0023_,'@{triggerBody()?['text']}') - This works fine

contains(Quote_x0020__x0023_,'@{triggerBody()?['text']}') - This produces below error and all I did was change the first word

The function operator 'contains' is not supported or its usage is invalid.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @Berrismfb ，

The problem is that OData filtering doesn't support the contains function, you can try this expression:

substringof('@{triggerBody()?['text']}',Quote_x0020_x0023)

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Berrismfb 8 on at

Like (0)

Report

Thanks, that worked great .... 🙂

Was this reply helpful? Yes No