cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dynamics1
New Member

Update Dynamics 365 Activity with Lookup Value

Hi, 

 

I'm trying Power Automate to fill in an account (custom field) lookup field on a Dynamics 365 custom activity record. But I cannot seem to make it work. The flow below works fine until the update record step. I get either error messages or completed flows without any update on the target record. In the flow I first capture the account from the regarding contact that is always filled in. But the problem is at the updating lookup step.

 

I tried many options to fill the lookup;

- Some blogs https://crmtipoftheday.com/1311/use-entity-name-in-flow-lookups/ say a lookup should be entered as accounts(...) with the accountid within the brackets. This gives me erros

- If I fill the account_id that I found in the Get Account step, the flow works fine, but does not update the activity record lookup.

- I can also not find the Common Data Service connector some people talk about. I can only find the Dynamics 365 connector - I checked my license also has a CDS option checked.

 

Help is appreciated,

 

Kind regards

 

 

 

 

Lookup.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Dynamics1
New Member

Always nice to fix your own issues.

 

So what fixed this:

- using the accountId from the Get Contact step (Instead of the one from the Get Account step). Don't know why. By my logic the Get Account step also has the account_id, and was working.

- not using any parentheses; accounts('accountid') was not working. 

View solution in original post

2 REPLIES 2
Dynamics1
New Member

Always nice to fix your own issues.

 

So what fixed this:

- using the accountId from the Get Contact step (Instead of the one from the Get Account step). Don't know why. By my logic the Get Account step also has the account_id, and was working.

- not using any parentheses; accounts('accountid') was not working. 

psycrkz1
Community Support
Community Support

Glad to know there is already has a solution by yourself 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,737)