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

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

Background:

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

 

Dilemma:

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

jasmine2020_0-1596654534686.png

 

 

 

 

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

Figure B

 

jasmine2020_1-1596654573046.png

 

 

 

 

Here is the CosmosDB data that hold this FeatureCategory attribute:

Figure C

 

jasmine2020_2-1596654598297.png

 


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:

 

 

jasmine2020_3-1596654635203.png

 

 

 

 

 

 

 


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?

 

jasmine2020_4-1596654684327.png

 

 

 

 

Any help or suggestions are appreciated.

 

0 REPLIES 0

Helpful resources

Announcements
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)