Unanswered

Connecting Google Sheets to Dynamics Look-up field

(0) Share

Report

Posted on by TCDowney

Hello,

I'm new to Flow but have intermediate knowledge of other programming.

I've connected a Google Sheet with very basic values (Name, Address, Email, City) to a Dynamics environment. I'm trying to create new contacts, which I have been successful with, but City is a look-up field to prevent misspelled city names.

I can't quite figure out how to do a look-up in Dynamics to select the appropriate City name.

Would love any help.

Thanks!

Screen Shot 2020-01-05 at 10.31.59 AM.png

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

abm abm 32,856 Most Valuable Professional on at

Like (0)

Report

Re: Connecting Google Sheets to Dynamics Look-up field

Hi @TCDowney

To set the lookup field in D365 you need to know the Id which is a GUID. To get the Guid you need to use a flow action list record (Here in your case city entity) filtered by City name. Once you retrieved the City GUID (Id) then you can map the city Id in your create action step.

Thanks

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Re: Connecting Google Sheets to Dynamics Look-up field

Hi @TCDowney,

You could use Get items action to filter out the ID of the item which city field located in, then obey the advice provided by the @abm , put the id into the city field of Create a new record action.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No