hello,
i’m unable to automate this process.
i have to take the value under “Year of Assessment” column in excel and correctly select the correct button in my web form
the problem is in excel it is in this format
please continue reading my next comment
continuing …
however in my web form it is in this format where it’s like a multiple choice , it’s buttons and i have to select the correct button respectively according to the year in “Year of Assessment” in my excel sheet
how can i read the year from “Year of Assessment” column in excel and correctly select the correct button for year in web form
for example if the value in excel is 2024, in my web form i’ll have to select the button for 2024
please help! been stuck for long
thanks
hello i’m sorry there are confidential data hence i’m unable to share it
but this is the part of the form that i have issue with selecting the button, it looks like this
i actually have another comment under the one you replied! you might have missed it :))
hi @vrdabberu here it is!
@meenyi ,
You can make dynamic selector to achieve this check the selector and if required you need to pass variable.
Regards,
Dheerendra Vishwakarma
Hi @meenyi
→ Use For each UI element activity and indicate the first option, it will automatically selects the remaining two options. Output is CurrentElement.
→ Click on Configure Filters and Inside that give like the screenshot below:
CurrentRow("Year of Assessment").ToString
→ Use Click activity and in properties Panel pass InputElement as CurrentElement.
As per your requirement I have made a flow for you check that once and try to replicate. If you face any issues let me know.
Input Excel:
Form:
Regards
hello! i’ve tried but i met this error 
please help! how can i solve this?
this is the error message:
24.2.1-beta.15932+Branch.release-v24.2.1.Sha.3f90483a69af341308fcab9ad25ddc1395738901.3f90483a69af341308fcab9ad25ddc1395738901
Source: For Each Row in Data Table
Message: Object reference not set to an instance of an object.
Exception Type: System.NullReferenceException
System.NullReferenceException: Object reference not set to an instance of an object. at UiPath.Core.Activities.ForEachHelper.GetValuesEnumerator[T](IEnumerable values)
at UiPath.Core.Activities.ForEachBase`1.StartLoop(NativeActivityContext context)
at UiPath.Core.Activities.InterruptibleLoopBase.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
— End of stack trace from previous location —
at UiPath.UIAutomationNext.Activities.NApplicationCard.OnFault(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.FaultWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
hello! may i ask what’s a dynamic selector and where can i find it?
thank you
hello! it’s the same column name tho😭 hence i’m u sure what’s the problem
regards
which activity do i check the column name for?
regards
Hi @meenyi
Can you share the screenshot of the excel. I hope you have changed the excel path in Read Range Workbook.
Regards
this is the excel
for the path in read range workbook, it’s the path of this excel file, is that right?
regards
hello i actually managed to figure out the error above, but currently i met another error where it is still not selecting the correct year in the form😭
even though all my processes are the same as yours. please help!
regards
@meenyi ,
are you using classic activity or modern ?
