Query CosmosDB, return value, if value matches, send value to CRM, if not send email

[jasmine2020]

I have built a flow that I would like to:

Query CosmosDB and return a value, if the the output value matches, send this value to CRM, if not send an email. 

This is what I have done so far:

**Does this conditional look correct for what I am doing?**

I am not sure if the inputs are correct here.

Any guidance will be helpful.

[abm · Accepted solution]

Hi @jasmine2020 

Couple of things to debug this.

1. Check your run history and see what it returns from the CosmosDB query step. Then check the condition value you are setting correctly (true expression or not).

2. I can see you are mapping Feature Category mapped with current item. Looks like that is not correct. Add a compose step above the CDS step and map the current item under the compose. Check the run history values and see what it returned under the compose action step. Then modify the below step accordingly. 

If you still struggling post a screenshot of your flow run history. 

Thanks 

[jasmine2020]

Great tips @abm Thank you. I am trying this now

[jasmine2020]

@abm  Could you clarify what this is saying?

My understanding is that it is saying: If the array output of the above query is true, then do this:

Then I have my true/false conditionals.

Any help is appreciated. Thanks 

[jasmine2020]

Hi @abm 

I am thinking this conditional may be correct? but not sure?

I wish to:

"iterate over each array element, match a specific value", this is essentially this step right?:

Because I am iterating over the array of elements that I just queried, and then if it equals the value I want (Query output of documents) then do.......xyz.....

This is my understanding, but I am not 100% sure..

Any suggestion is helpful.

[abm]

Hi @jasmine2020 

What happens when you run this flow? Without seeing your run history data its difficult to give you an exact answer.

Thanks