How to Map Excel Product Rows to Data Service Records Efficiently in UiPath

Help Data Service
1

I have an Excel sheet with products (Product A, B, C) each with different pricing. I want to:

  1. Read the Excel into a DataTable in UiPath.
  2. Match each product with its corresponding record in a Data Service entity.
  3. Calculate/update fields such as Previous Price, New Price,

I’m looking for the most efficient way to match Excel rows to entity records.

2

First, read the Excel file into a DataTable using Read Range.

Then get all the records from the Data Service using Get Entity Records.

Convert these records into a Dictionary, so you can quickly find matching records by product name.

Next, loop through each row in the Excel table and check if the product exists in the dictionary.
If it matches, update the fields like Previous Price and New Price using the Excel values. Add all updated records to a list.

When the loop is finished, use Update Entity Records to update everything at once.

3

@Daniel_Oisebe,

Please share what are the approaches you have already tried and any specific issue resulted in you finding the most efficient way.

4

Hi @Daniel_Oisebe

Try this steps;
Read Range → Query Entity Records → Join Data Table → For Each Row (update fields) → Update Entity Records

Happy Automation

5

This is my process in a nutshell:
Read Range → For Each Row (store customer name & pricelists)→ Query Entity Records → Find match(Between Data table and Entity Records) → Update records where applicable

6

The challenge is the price column in the Data service Entity (“Pricelist”) is different from the datatable (“Cost”)

7

You can map this specific col inside loop like
entityRecord.Pricelist = CDec(row(“Cost”).ToString)