Lookup Data Table?

[Enzo_Rossetti]

Hi Guys!
I wanted to know how to make a lookup of 2 tables.
Then I have to insert the value in the other sheet. What I want to know is how to make the details come out on sheet2. This is a smaller example of what I have to do hahahaha but this will help me.

[AshwinS2 (Ashwin S)]

Hi @Enzo_Rossetti

Use read range for both the sheets

Use for each row

Use build datatable activity
Add data row
{Row(“color”). ToString,row(“details”). ToString,row(“cdetails”). ToString} pass these values
In array row property
Use write range
Thanks
Ashwin.S

[Mohansadaiyapillai (Mohanraj S)]

LookUp.zip (20.4 KB) @Enzo_Rossetti,

I have created a workflow based on your requirement.

Please see this and reply back to me if any additional details.

Thanks,
Mohanraj.S