How Do I Extract Excel information and make it choose a specific dropdown Selection in google forms

Help Activities
, ,
1

Hey there. I have tried looking at video that will help but nothing has seem to be working. If you want I can send the whole file if you need a closer look but I am not sure how to fix this. Solutions would be helpful. Thanks

2

Read Range into a datatable. Use Application/Browser to open the web page. Inside it, For Each Row in Datatable. Inside the loop, Type Into with CurrentRow(“yourColumnName”).ToString

4

I have all of that already, I just need to make it so that it select the dropdown box and selects the certain correct choice automatically. This does not answer the questions on how to do the dropdown box

5

Hi @dolx

Use the Read Range workbook activity to read the excel file and store it in a datatable.
If you want to fill every row data in to the each google form. Use for each row in datatable activity to iterate the every row of datatable.
Take the Use applcation\browser activity to open the google forms in the chrome and indicate the forms.
Use select item activity to select the option in the dropdown, give the value in the select item like Currentrow(“Column name”)
If you want to enter the data in the fields you can use the Type into activity to write the data in the forms.
After all the entries in the fields use the click activity to submit the forms.

Check the below workflow for better understanding.

image
image880×1198 67.6 KB

Note - Make sure to encapsulate the Ui element activities with in Use application\browser activity.

Hope it helps!!

6

There is an activity called “Select Item” which can be used to select dropdown values. You can pass the excel value (the value to be selected) as input for the select item activity.
https://docs.uipath.com/activities/other/latest/ui-automation/select-item.

7

I dont think this has answer my question. I need it to choose the correct dropdown menu based of the excel spreadsheet. Here is an image example underneath to explain the process.

image
image906×390 12.7 KB

It should be able to automatically fill the dropdown based off the table results. I dont know if I am explaining it incorrectly but it should be able to do otherwise. I watched this video:
UIPath read excel and enter the data into web forms - YouTube and at 19:55 it shows how to do this but I don’t know why it is not working for me.

Thanks

8

Hi @dolx
Use Select Item Activity
image
In Item to select give this

CurrentRow(“Prefered Gaming console”).ToString

9

It only allows me to indicate in excel for some reason. Any way that I can fix this?

10

This is what it currently looks like for me
image

11

Use the activity “use application/browser” and indicate your webpage and place the select item activity inside this activity. Currently its showing Excel file because you may be using the select item activity inside and excel application scope/ a “use application/browser” activity which is pointed to an Excel file.