Answered

Searching a string within an object

(0) Share

Report

Posted on by powerdevkris

142 Season of Giving Solutions 2025

I have an object output like below that i want to check if the word ORANGE exists on one of the text field. Is there a way to do it without using any loops? Like an expression?

{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"page": 1,
"lines@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
"lines": [
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"text": "APPLE",

{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"text": "ORANGE",
"boundingBox": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@powerdevkris ,

You could try the indexOf function in the expression. If the searchText exists, it returns a positive number

indexOf(text,searchText)

Was this reply helpful? Yes No
powerdevkris 142 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Passing the whole object on the first parameter will hit this error.

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'indexOf' expects its first parameter to be of type string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#indexof for usage details.'.

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Maybe use a Compose to convert the object to string.

Then apply the indexOf function on it.

Option two is to loop through the items in apply to each and just a condition by comparing the "text" value to "ORANGE"

Was this reply helpful? Yes No
powerdevkris 142 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

This one works for me. Thanks!

Maybe use a Compose to convert the object to string.
Then apply the indexOf function on it.

Was this reply helpful? Yes No