Hi @postwick I don’t know how many color rows will be available in my sheet. If i go row by row and doing color match it will be lengthy and difficult process i guess but i will try this once. Do we have ant alternate way to do it.
You could create a datatable with the same columns as the Excel file, plus a row for color. In your For Each Excel Row you use Add Data Row to add the Excel data to the datatable plus the color. Then after that you could loop through the datatable and use Filter Data Table to find all the rows of each color. That would make it so it works even if the colors aren’t all grouped together in the Excel file.
Hi @Shiva_Nikhil , is there any option to do without specifying the color. Because i don’t know what color i will receive there. If it’s possible to pick any colour that will be good. I will check once again if the color format is same then this will be enough.
Hi @Benjamin_Vazquez1 Do you have this code in VB and i’m not using modern design flow also. When i try to create same flow separately it is throwing me error.