I have one excel sheet. Which have multiple columns. I have to read the sheet and put all the details in the web application(D365).
It has one column “Order Identifier” from which you have to create the record. It may have multiple records so you have to put these all data in the application but it will create only one Record Number.
those all have Order Identifier value 1 so it will create only one order.
Another scenario is like you can’t put these store numbers quantity in the table you have to go one by one using search option and put these quantity in the particular text box. For Example: first, it will search 1010 and put 1 in the text box then it will go to 1030 and put the value 4 in the text box.
Any help how can I do that?