web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Creating Flow to update Account Records

(0) ShareShare
ReportReport
Posted on by 45

Hi,

I'm currently in the process of Importing data into dynamics. When uploading Accounts and Contacts, we noticed that the Primary Contact field in Accounts doesn't get filled. So to avoid having to upload accounts and then export all the accounts, make changes and then re import accounts we decided to use a flow to facilitate this.

I've created the flow using the CDS to make the updates, and the flow is successful. However, the changes aren't actually applied to Accounts, still leaving the Primary Contact Field empty.

Can someone please help me with this issue?

I have the same question (0)
  • meelamri Profile Picture
    13,216 User Group Leader on at

    Hi

    Can you please share your update action using some screenshots ?

  • Sam Hef Profile Picture
    45 on at

    Sure, here is what I have:

    It's not much since I don't know what needs to be done to achieve desire results.

    6082.InkedScreenshot_5F00_2020_2D00_05_2D00_07-Edit-your-flow-Power-Automate_5F00_LI.jpg0045.Screenshot_5F00_2020_2D00_05_2D00_07-Edit-your-flow-Power-Automate_2800_1_2900_.png

  • Sam Hef Profile Picture
    45 on at

    Updated the flow with a condition, so that if the Primary Contact Field (which I created) contains "Yes", then a Get Record method runs to verify the record is there, then Update Record method runs and updates the Primary Contact in Accounts with the Contact that was created. I'm getting the response/error:

    {
      "statusCode"404,
      "message""Resource not found"
    }
    2671.Screenshot_5F00_2020_2D00_05_2D00_07-Run-History-Power-Automate_2800_1_2900_.png
  • Suggested answer
    meelamri Profile Picture
    13,216 User Group Leader on at

    Yes I understand your pain, it's a known issue. CDS connector need a little expression to set a lookup. Please refer to this blog to resolve your issue: 

    https://daytodaydynamics365.com/referencing-records-when-using-the-common-data-service-current-environment-connector/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 60 Most Valuable Professional

#2
#ManoVerse Profile Picture

#ManoVerse 51

#3
Satyam Prakash Profile Picture

Satyam Prakash 42

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans