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
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
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.
Hi,
found a similar problem and made my flow with their solution.
@abm I believe you meant the same, thx
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?
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
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1