Condition on excel sheet

Like did u mean u need to enter all the order 1 details once while order2 for once like that?

yes , as i have to put them into a form and save it order by order

Hi @rpa13
Check this workflow
Main.xaml (13.9 KB)

I had added the comments so that it can help in designing the workflow rest.

Nived N
Happy Automation

it doesn’t work can you provide me with sheet to understand what you mean

error with that variable

U can add ur sheet as input there

Sorry it should be

dt2= dt1.DefaultView.ToTable(True,“order”)

ask.xlsx (11.0 KB)

Hi @rpa13
try this workflow
ask.xlsx (11.0 KB)

Main.xaml (13.9 KB)

you may not understand me as i will get unknowen number of orders

I did not understand ur requirement well

enter the sku’s with same order number (example order no 154) and save them , then
enter the sku’s with same order number (example order no 155) and save them and so on

@rrenu59 @Adrian_Star if you can please help in this thanks in advance

Hi @rpa13 !
Here is a suggestion:
Condition_on_excel_sheet.xaml (12.9 KB)
Don’t forget to adap your read range with your filepath and sheet name.

To understand more, I recommend you to use debug mode. I have left on purpose breakpoints in strategic points. Each time the robot does a break, in the local panel, watch carefully the variables sku, increment_id and temp_DT.

To write in the right line in All items table (in your website), do you know how to do ?
If no, use UiExplorer and indicate these elements and send us a screenshot of what you see:

and indicate the following fields (so we need 2 screenshots):

i got this error

Using exactly the same data you sent us as a screenshot (the 3 columns + 4 lines) ? with my sample it works:

Can one order_ num have more than one incrementID?? Only sku differs with every combination of order_num and increment_id right?

I checked the flow of @Hiba_B and it works well. :slight_smile:

When working with Sheet4, you need to customize the column names in the workflow.

Column order_number to order.
Column sku to *product



no ,every order number has one increment_id with differ sku and qty

i try to put each order example in screen shoot i add qty colom in my sheet
as i work on sap system not website
Condition_on_excel_sheet.xaml (39.1 KB)