Set CRM Dynamics Lookup

(0) Share

Report

Posted on by stuaz

I have an app which I built that allows a user to update a record in our Dynamics CRM application (On Premsis).

However when the user 'saves' on the app I need it to update a lookup field in the same record.

The lookup field is to another entity in Dynamics, however I don't know how to retrieve the GUID for the other entity.

There is a "link" between the two entities in the form of a text field in the main entity which is also unqiue and is in the entity I wish to link to.

However I am not sure how within the app I can retrieve the ID of the other entity based on this relationship and then set that in the new field.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi stuaz,

Please try to use Lookup function to retrieve the ID.

There should be a common field between the two entities, then you could configure the Lookup function likes:
Lookup(entity1,entity1.title=entity2.title,ID).

This blog could also be a reference for you:
https://community.dynamics.com/crm/b/alexanderdevelopment/archive/2017/02/23/working-with-dynamics-365-lookup-data-in-powerapps

Please try it on your side and feel free reply if you need more help.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
bslahsen 23 on at

Like (0)

Report
Copy link

Link copied!

Hello! I would like to ask how are you connecting to Microsoft Dynamics CRM? I can't find any suitable connector.

Appreciate your help!

Was this reply helpful? Yes No