I want to make it dynamic-like, where a new menu is added in the application, I will update that control name in an excel file, and the bot will try to take an action according to the menu value.
Its a single page application with 30 controls, i want to skip 30 if else logic
If you want to make it fully dynamic, then it means that for each control on the page your robot must be able to:
Detect the corresponding name from the Excel file
Detect the corresponding type of control (text, multiline text, multiple choice, etc…)
Dynamically use the corresponding action (i.e., Click, Type Into …) based on the type of control
Dynamically use a selector that will find the corresponding control based on the control type and name
Set the value based on what it found on the Excel file for that control
From what I can see, the Excel file you’ve shared, you didn’t take into account the fact that the control type is relevant for this dynamic behavior.
This dynamic implementation might be feasible (and I say “might” because it’s hard to say without acessing your application and really seeing what you’re doing) but it will require you to write very generic code and sequences that will work for a multitude of selectors, control types and values (most likely with some Select…Case options, sub-sequences, etc…)
Does it appear after you click something? Or before the main window is loaded? Generally speaking, you should be able to check it. Did you try? If you did, which issues were you facing?