Hello Friends,
I have one Intex Mobile Store Locator Website which is “https://www.intex.in/store-locator”. I pass State as Maharashtra in One Dropdown and All Cities of Maharashtra from the excel sheet in another dropdown. I get Store Locator info such as Store Name, State, Address, Phone No using Data Scrapping and I store into separate Excel sheet using Write Range. Now I need City And State from Address for particular store info separately,
for example, I need Pune City for State Maharashtra and want to Store in Columns along with Store Name, State, Address and Phone number.
I need Columns such as Store Name, State, Address, City, State and Phone Number in Excel. I tired with merging DataTable and also tried using Trim function and Array on Address to get City and State separately. But sometimes for some cities, I am getting Address as output in Message Box for cities. But I need only City Name separately along with State and I need an output Excel sheet. Please suggest me a proper solution to this problem.
I am attaching Screenshot of Flow and Workflow and Excel. Please suggest to me flow as early as possible.
Hey Sarathi, I tried to run this xaml in UiPath Studio but I am getting error as "RemoteException wrapping UiPath.Core.SelectorNotFoundException: Cannot find the UI element corresponding to this selector: —> RemoteException wrapping System.Runtime.InteropServices.COMException: Cannot find the UI element corresponding to this selector: **
** at UiPath.UiBrowserClass.Find(String bstrSelector)
** at UiPath.Core.Browser.Find(Selector selector,** IPlaceholderResolver placeholderResolver)
** — End of inner exception stack trace —**
** at UiPath.Core.Activities.ScopeActivity.EndExecute(NativeActivityContext context,** IAsyncResult result)
** at UiPath.Core.Activities.AsyncNativeActivity.BookmarkResumptionCallback(NativeActivityContext context,** Bookmark bookmark, Object value)
** at System.Activities.Runtime.BookmarkCallbackWrapper.Invoke(NativeActivityContext context,** Bookmark bookmark, Object value)
** at System.Activities.Runtime.BookmarkWorkItem.Execute(ActivityExecutor executor,** BookmarkManager bookmarkManager).
Hey can you share the Screenshot of DataScrapping of the workflow.