Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Using Connectors
Answered

Connection 2 entities in Common Data Service

(0) ShareShare
ReportReport
Posted on by

Hey,

I have made two entities: "Scans" and "Products" in Common Data Service. When a scan is taken (trigger action: When a record is created), I want to change some fields of the entity "Products" (action: Update a record). With the scanned barcode, you can find the correct product. In other words, the column 'Barcode Scan' (of entity Scans) is the same as the column 'Barcode Product' (of entity Products). I have tried several ways to do this, but always struggled with finding the Record Identifier in the "Update a record" action.

Can someone find me a way to do this?

Kind regards,

Jelle

 

  • abm abm Profile Picture
    32,506 Most Valuable Professional on at
    Re: Connection 2 entities in Common Data Service

    Hi @Anonymous 

     

    If your problem has solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

     

    Thanks

  • abm abm Profile Picture
    32,506 Most Valuable Professional on at
    Re: Connection 2 entities in Common Data Service

    Hi @Anonymous 

     

    There are couple of ways you can resolve this.

     

    What I meant by mapping the variable is use the set variable action step to assign the identifier (GUID). Then outside the loop you can use the variable name to update the record using the above identifier. 

     

    Yes also you could do the update inside the for loop like you mentioned in below url.

     

    Glad to hear that you have resolved the issue.

     

    Thanks for the update.

  • Verified answer
    Community Power Platform Member Profile Picture
    on at
    Re: Connection 2 entities in Common Data Service

    Hi,

    found a similar problem and made my flow with their solution.

    @abm  I believe you meant the same, thx

    https://powerusers.microsoft.com/t5/Building-Flows/Using-Get-Record-Action-in-Common-Data-Service/m-p/265927/highlight/true

     

  • Community Power Platform Member Profile Picture
    on at
    Re: Connection 2 entities in Common Data Service

    hi @abm ,

    Thx for the response.

    I have made the flow till step 5b. I don't understand exactly what you have to do in the loop. What do you mean with assigning 2 variables to each other? How exactly do you do this?

    • Do you put 'Value' under the "Select an output from the previous steps?
    • Which action do you use to assign those 2 variables to each other?
  • abm abm Profile Picture
    32,506 Most Valuable Professional on at
    Re: Connection 2 entities in Common Data Service

    Hi @Anonymous 

     

    What you need is the following steps:

     

    1. Trigger when a record is created
    2. At this stage you have barcode
    3. Declare a variable called ProductId (String)
    4. Add a step called List Record filter by barcode against your Product entity (Set the filter query as Barcode eq 'your triggered bardcode value')
    5a. Add a for each loop
    5b. Inside the loop get the product identifier (Unique Id/Primary key) & assign to variable ProductId
    5c. End loop
    6. Next you can use the Update Record using the Product Id

     

    Any questions please let me know.

     

    Thanks

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Featured topics