cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Microsoft flows: Map Dynamics 365 lookup value to SharePoint look up.

We have Customer and Lead look up on a Internal Request(custom entity) in Dynamics 365. Similarly, Customer and Lead look up on 'Request' Sharepoint list.  Microsoft flow will trigger on Internal Request(D365) record creation.

 

I need to map Cust/ Lead lookup (D365) with Sharepoint's Cust/Lead lookup list. For example: I have created one Internal Request record in D365 and entered  'Deloitte' in the Customer field. Now using Microsft flow, I need to check if Deloitte is present in the customer list in SharePoint, if YES, map it with the customer fields in the Request list. And If NO, create a item in the Customer list(SharePoint) and map it in the looup field of Request list.

 

I have just started working working with Microsoft Flows and Sharepoint. I might have not used the correct terminologies.  

 

Thanks & regards,

Mahak J

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

I tried to map CRM lookup value with Sharepoint look up....

I tried to map CRM lookup value with Sharepoint look up.Triggering MF on create of Internal Request entity, Getting it's account details then getting customer Entry Item in share point based on account name. and mapping the ID in the final Share point Request list.Triggering MF on create of Internal Request entity, Getting it's account details then getting customer Entry Item in share point based on account name. and mapping the ID in the final Share point Request list.

Untitled.png

 

But I have one question here, how can I give the condition if the account lookup is null in the Internal Request(Dynamics 365). I am using below(img) condition but it is not working.

Untitled.png

View solution in original post

3 REPLIES 3
Solution Sage
Solution Sage

Re: Microsoft flows: Map Dynamics 365 lookup value to SharePoint look up.

Hi @MahakJain ,

I am afraid that there is no way to achieve your needs in Microsoft Flow currently.

As you said, the customer is a lookup column.

So you can only set the column value based on the lookup column valus.

When you add  'Deloitte' in the Customer field in Dynamics 365, if the value isn't present in the customer list,

you can't add the value to the list. You can only choose the value from the 'Request' list.

As the pic shown, you can ony choose the value from the lookp column.

Capture2.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Highlighted
Frequent Visitor

Re: Microsoft flows: Map Dynamics 365 lookup value to SharePoint look up.

Thanks @v-zhos-msft for the quick respose.

 

What I understood from your response is that we can't check in microsoft flows if the company is present in sharepoint lookup list or not. Is it correct?

Highlighted
Frequent Visitor

I tried to map CRM lookup value with Sharepoint look up....

I tried to map CRM lookup value with Sharepoint look up.Triggering MF on create of Internal Request entity, Getting it's account details then getting customer Entry Item in share point based on account name. and mapping the ID in the final Share point Request list.Triggering MF on create of Internal Request entity, Getting it's account details then getting customer Entry Item in share point based on account name. and mapping the ID in the final Share point Request list.

Untitled.png

 

But I have one question here, how can I give the condition if the account lookup is null in the Internal Request(Dynamics 365). I am using below(img) condition but it is not working.

Untitled.png

View solution in original post

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,645)