Need help on AND expression

(0) Share

Report

Posted on by Ramazan_BIYIK

Can someone please combine this two expression with AND expression:

1-) contains(items('Apply_to_each_2')?['title'], triggerBody()?['repository']?['name'])

2-)contains(items('Apply_to_each_2')?['title'], triggerBody()?['issue']?['id'])

I tried @and(contains(items('Apply_to_each_2')?['title'], triggerBody()?['repository']?['name']),contains(items('Apply_to_each_2')?['title'], triggerBody()?['issue']?['id'])) But it didn't work

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

vecerpa 786 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ramazan_BIYIK,

What is the message that you receive by Flow or Flow designer?
P.

Was this reply helpful? Yes No
Ramazan_BIYIK 49 on at

Like (0)

Report
Copy link

Link copied!

Actually no message showed on compile. But showed on running. This is the error.
I manage that error with changing the code with @and(contains(items('Apply_to_each_2')?['title'], triggerBody()?['repository']?['name']),equals(items('Apply_to_each_2')?['title'], triggerBody()?['issue']?['id'])) . But this time it didn't work as ı expected.

Please check that picture. It works and what i am looking for. But 2 condition after and after make no sense. There must be a way to combine this 2 condition.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
Copy link

Link copied!
Hi @Ramazan_BIYIK,

Could you please share a full screenshot of your flow's configuration?

Could you please show a bit more about these actions within the "Apply to each 2" action?

Further, could you please show more details about the erroe message?

I have made a test on my side and the issue is confiormed on my side. The error message shows up as below:

The error message told that there is something wrong with the contains function. The contains function expects its two parameters matching following types:

contains(a dictionary, a key (string))

contains(an array, a value (object))

contains(a string, a substring)

But the result the triggerBody()?['issue']?['id'] expression (Id dynamic content) returned is a Integer type, so the error occurs. Please take a try with the following formula within your Condition box and check if the issue is solved:

@and(contains(items('Apply_to_each')?['title'], triggerBody()?['repository']?['name']),contains(items('Apply_to_each')?['title'], string(triggerBody()?['issue']?['id'])))

I have made a test on my side and my flow's configuration as below:

The flow works successfully as below:

Best regards,

Kris

Was this reply helpful? Yes No
Ramazan_BIYIK 49 on at

Like (0)

Report
Copy link

Link copied!

Thanks Kris for suggestion. Well explained. I later tried on different flow. I need to combine one string and one integer value with and expression. String values need ' that. Like 'My_string value' but int don't. So the query should be like """ my_database_column1 eq 'my_string_value' and my_database_column2 eq my_integer_value """

Was this reply helpful? Yes No
980Panama 140 on at

Like (0)

Report
Copy link

Link copied!

I had a similar problem needing multiple NOT Contains conditions and came up with the syntax below based on the helpful comments above.

@and(not(contains(item()?['DisplayName'], 'log')),not(contains(item()?['DisplayName'], 'marketing')),not(contains(item()?['DisplayName'], 'recei')),not(contains(item()?['DisplayName'], 'distribution')),not(contains(item()?['DisplayName'], 'financial')),not(contains(item()?['DisplayName'], 'invention')))

Was this reply helpful? Yes No