Unanswered

Get Dynamics 365 Contact Record using SharePoint list dynamic content?

(0) Share

Report

Posted on by FrancoPrussian

Hello, I would like to get a Dynamics 365 Contact record based on dynamic content from a SharePoint list item. I was thinking I could use the value for "Submitted By Email" from the SharePoint list to lookup the corresponding Contact in Dynamics 365. I tried using that for the Item Identifier but it errors out. What am I missing? What should go in the Item Identifier field?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FrancoPrussian,

The item identifier is the GUID which represents the Dynamics 365 record.

Thanks

Was this reply helpful? Yes No
FrancoPrussian 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, is there a way to use the email address to lookup the GUID?

Was this reply helpful? Yes No
abm abm 32,998 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @FrancoPrussian,

Yes you need to use the list records to filter the GUID. Please see below,.

Was this reply helpful? Yes No
FrancoPrussian 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks abm, I can't quite replicate your example below because I don't have dynamic content from Dynamics at this stage; I am starting from a SharePoint list entry and trying to lookup a GUID in Dynamics. Using your example below, I tried to filter the query as shown in this screenshot, but it is giving me a syntax error "Syntax error at position 40 in '_emailaddress1_value eq fred@synaxiscorp.com'.\", where fred@synaxiscorp.com was the value pulled from the SharePoint dynamic content (i.e., Created By Email, as shown in screenshot). Any idea where I'm going wrong with my syntax?

Forgot to mention: emailaddress1 is the field name in the Dynamics Contacts entity that I'm trying to use for the lookup.

Was this reply helpful? Yes No
abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FrancoPrussian,

Try _emailaddress1_value eq 'fred@synaxiscorp.com'. Let me know the results.

Thanks

Was this reply helpful? Yes No