I am trying to pull Cosmos DB data into CRM and want to use these record in Lookup field. What I have achieved as of now is, I am able to connect Cosmos DB with Virtual Entity and when I use VirtualEntity in Advanced Find I can see all the record. In Cosmos, I have AccountGUID as text, OpportunityGUID as text and OpportunityName.
Problem When I click on the lookup I can see only one record (In cosmos DB I have 5 record) and after selecting listed record in lookup when I click on that record, it's not getting redirect to Virtual entity form. Can someone guide me how can i achieve this task?