LogicApp that returns newly generated ID back to original source

Question

Hello I am trying to create a LogicApp that first:

1. Extracts data from CosmosDB, using a query
2. Loops over the results
3. Pushes the results data into CRM

Sidenote: Once this data is pushed into CRM, CRM automatically generates an ID for each record. How can I then:

4. My biggest dilemma is figuring out how can I return the newly generated ID back to the original CosmosDB container in which it was pulled from?

I have started on this and these are my questions:

Does this first part look correct in what I am doing? I must use this SQL query for this:

a. I am simply telling the Logic App to extract data from a particular container inside CosmosDB

b. Then I would like to loop over the results I just obtained, and push this to CRM

c. My dilemma is: Once data is pushed to CRM, CRM then automatically generates an ID for each record that is uploaded. How would I then return the updated ID to cosmos? I am not sure how to construct this in LogicApps and have been researching examples of this.

Any help is greatly appreciated.

Thanks

Answer 1

Duplicate post to #52165