How to use select item with dropdown whilst using excel process scope

Hey there. I need some help trying to figure out how to automate the process of filling in a form/dropdown select in a form through results in a excel table. I have provided images of everything that I have currently done.



tempsnip

@dolx

Hi,
Use “type into” activity to select an item in the dropdown list give the excel input data in the type into .For example CurrentRow(“Your Column”).ToString

Hope it will help you

Hi @dolx

Store the datatable values in a variable.

  • Assign → GamingConsloe = Currentrow(“Prefered Gaming console”).toString
    Pass this variable to the select item activity then it will select the item from the dropdown automatically.

Drag and drop the select item activity inside the for each row in datatable.

Hope it helps!!

Seems like you have indicated the wrong application to select. Try selecting the dropdown in the google form and then to enter the value, use CurrentRow(“Prefered Gaming Console”).ToString .

Hey there, unfortunately this should work but it doesn’t. It is because i am currently using the excel tasks to do this and it only allows me to indicate in excel. Any other way to use an excel file without having this problem and if so how? Thanks!
image
(This is the problem that i am experiencing)

Have you used the assign activity under the for each row in datatable and select item has to be place inside the Open browser activity.

Could you please provide the screenshot of all workflow. @dolx

If you want to read the excel don’t use much activities like use excel file and read range, simply use the read range workbook activity.

Hi @dolx

Make sure your Forms sequence within the scope

Hi @dolx

You can indicate the element in outside the excel scope and drag it into the inside excel scope.

Make sure the select item activity present in the use application/browser scope then it will give the choice to indicate the item in browser.
image

All the information and sequencing is in the first message that i have sent.

I dont know how to do that, i currently just have it in a use browser but whenever i use “Use application/browser” It never works.

Could you please make some changes. Instead of using the excel process scope, use excel file and read range remove all this and use the read range workbook activity to read the excel and store it in a datatable. After this use application\browser activity inside this use for each row in datatable after that give type into and select item activities. It was the correct workflow.

I hope you got it. @dolx

@dolx

Try Update to the latest version -“UiPath.system.activities” package

It just gives me this error when i try to run. Also should i put use application in the inside of each row in datatable?
image

for the pipeName variable you haven’t initialized any value.

Better to send me the screenshot then we get better understanding. If you haven’t any important information in that.

Idk what you mean by send you a screenshot. I feel like it would be a lot easier if i could like show you the problem through my computer screen.


This is what it currently looks like with your advice

Now it was in correct format. Could you please remove the unused variables and arguments in your workflow.
@dolx

I only have one which is called mydata. You can see it in the screenshot i sent before.

@dolx

Please move your use browser activity outside the use excel file activity…as anyways you are reading data into datatable you dont need it now…

And then try indicating the required element on ui screen

Cheers

Once do debug the whole program then which activity it was throwing what error it was throwing provide the screenshots of it. @dolx

Hello @dolx

Open the below xaml file I have automated with your Inputs.
Demo.xaml (20.6 KB)

In read range workbook change the file path.
For that the select item activity is not working for that dropdown that’s why I have given type into activity with Click Enter.

If it resolved let me know

Hope it helps!!