Moving Data Into SharePoint List Returns GUID instead of Text Value

[nkohlen01]

I'm trying to pull Contact information from Dynamics 365 Sales Enterprise into a SharePoint List. Everything is working except for Company Name. When filling out a contact card the Company Name basically looks it up from the Accounts Table (My best explanation). 

I've tried using Company Name (Value) and Account (Value), but it doesn't matter. Both return a GUID. 

 

SharePoint List (Company Name Column Returns GUID)

[Cayshin]

It's returning the GUID because the Company field is probably a LookUp column to a Company table. The GUID is the unique ID of that item in the Company table. There are two ways we can retrieve the actual name.

Option 1) In your DataVerse action that's retrieving the info, look at the body content (may help to copy+paste into notepad/notepad++).

Search this output for the Company line. In my example, I'm trying to retrieve the name of the person who owns a Contact record.

See how there are multiple _ownerid_value lines with some that have an @ followed by other text?

What we can do is find the specific line that holds the actual Name value we want and use that field name as the content we'll use in the "Create item" action.

I often do it by dropping the in (Value) dynamic content, then copy+pasting that dynamic content into the Expression bar where I then manually type the rest of the fieldname (@...)

Option 2) Have a Dataverse "Get Items" action that queries your Company table for that guid. Then there should be a dynamic content from that output that has the actual name.