cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Query cosmosDB, extract matching items, if items do not match, send email

I am setting up this LogicApp and want to see if my approach is correct:

 

 

I wish to push data from CosmosDB into CRM, and then return these items back to CosmosDB and replace its ID. Not all of the push to CRM is direct due to some of CRMs fields consisting of 'lookup fields'. I have a list of the GUIDs for the lookup fields, but not every record has a match. For the records that do not have a match, I wish to send an email. This is my flow so far:

 

jasmine2020_0-1596678714476.png

jasmine2020_1-1596678770641.png

jasmine2020_3-1596678829257.png

 

jasmine2020_5-1596678888865.png

 

 

I am unsure of my highlighted fields here. Is this the correct approach?

Any suggestion or advice is appreciated

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Query cosmosDB, extract matching items, if items do not match, send email

Hi @jasmine2020,

 

The "Array of ..." seems like an array, the "Document" is an Object, so the comparison not correct.

If you want to compare two fields, you should make sure the two fields are same type. If you want to confirm an array contains a string, use "Contains" condition will be correct choice.

Annotation 2020-08-28 095124.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,103)