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.
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!
(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.
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
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?
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.
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!!
parvathi_ayanala
jamiejam
Anirudh_Tugawe