Hi everyone,
I’m facing a challenge in planning an automatic robot, specifically regarding “multiple-choice” scenarios. Do any of you have suggestions on how to automate the selection of these “multiple-choice” options based on data from Excel? In my project, the data source comes from an Excel file.
If you don’t mind, could you please provide an overview of how it can be implemented? Thank you
@Actanzil
Is it possible to share the google form link?
Hello, thanks for responding to my issue. Here is the Google Form link.
this is link form https://forms.gle/XmrVGfUgsaw976TT8
and here file excel
1 Like
Hi @Actanzil
→ Use the for each Ui element activity and indicate the first option, it will automatically selects the remaining two options. Output is CurrentElement.
→ Inside for each Ui element activity insert the if condition and give the below condition.
CurrentElement.equals(CurrentRow("Column name")
→ Inside if condition insert click activity and pass the currentElement to the Input element option in properties of click activity.
Hope it helps!!
Inside If condition delete the three click activities and insert only one click activity don’t indicate any element just open the properties of click activity, find the Input element option and pass the CurrentElement.
By doing this based on condition it will automatically selects the option.
Hope you understand!!
Yes @Actanzil
Perfect, execute and check it’s working or not.
If works, make my post Mark as solution to close the loop.
Happy Automation!!
It seems to not be working well, as it failed to select from the provided options. If you don’t mind, would you be willing to guide me if errors occur?
Okay @Actanzil
You have to make changes in the workflow,
→ Delete the If condition inside the for each Ui element activity.
→ Open the Configure Filter option and pass the CurrentRow(“Column name”) in the value field, check the below image for better understanding,
→ Inside for each Ui element activity insert the Click activity and pass the CurrentElement to the Input element option in properties.
Check the below workflow for better understanding,
Regex_Practice.xaml (24.2 KB)
It’s working for me.
Hope it helps!!
1 Like
Yay, it’s finally working well. Thanks for the solution you provided. Stay healthy, good person 
1 Like
It’s my pleasure… @Actanzil
Happy Automation!!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.