I am confused in select item activity because i have a dropdown values and read from excel but in excel type value is differ from the dropdown values in Excel(JS MEANS JETSKI).How to use this approach.
This is dropDown Value
this is my excel input
To use the Select Activity the values should be exactly matching in the excel as well as in the drop down.
JS MEANS JETSKI)
Let’s standardise the input excel file here
Which means have a separate column at last which will have the actual value for each type and we can choose that value in the list box
So in your excel include a new column atlast and for each type (as in second column) mention the exact corresponding value that we can search in list drop down box
Once included input gets standardised and read that excel file with read range activity and get the output as dt
Now use a for each row activity and dt as input and inside the loop use select item activity and mention the value as
So that you can select now the exact value you want