Showing results for 
Search instead for 
Did you mean: 

Recognize 'lookup' ID's (CRM) according to values in CosmosDB and set it into a Logic App


I have data coming from CosmosDB that needs to be pushed into CRM. I am using a LogicApp for this.



There are multiple IDs that have different attributes associated with them:
For instance the 'ems_featurecategoryid'. Each has a different name that goes along with its unique ID. (This the raw data that is within CRM)

Figure A






Here is the CRM interface and the lookup field (feature category) in which I wish to push the CosmosDB data into:

Figure B







Here is the CosmosDB data that hold this FeatureCategory attribute:

Figure C




There are over 3000 of these. How would I map the IDs that are within CRM (Figure A) with CosmosDB (Figure C), so that when a value input is provided to the Feature Category lookup in CRM, this is recognized according to the value in CosmosDB?

This is what I am thinking:











I provided the Logic App with one of the GUIDs from Figure A. I am not sure if this is the right thing to do. The value is pushed through, but how do I account for all of the other IDs?







Any help or suggestions are appreciated.



Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (3,031)