Answered

Connection 2 entities in Common Data Service

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
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?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

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

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

Like (0)

Report

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.

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

Like (0)

Report

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

Was this reply helpful? Yes No