Hello,
I am reading url from excel using read cell instaed of nornal get row item because i need to read the speciic url where column color is red.
but when i am opening or passing the value which is store in readcell for url , url unable to open properly.
what could be the issue? what the another way?
help em on same
Can you show your flow and input, how it will be.
first check your input,
next use use debugging option
use a log message to print the read cell output.
then take that value and cross check with actual URL and Excel URL what exactly updated in excel.
Happy Automation!!
Use read range instead of read cell, then filter rows where color = red and get URL from filtered datarow Or use read range + for each row + if (color = red) → get URL with row(“URL”).ToString.Trim
Happy Automation
Add log message to log the variable which is storing the URL and check what you are trying open. You can share what you are getting there.
Use Go to URL activity to navigate to the URL.
What kind of a url is it? Is it for opening a web application or some file download direct URL?
Also when you copy that url manually and try to open, does it work?
If it does, then problem is with how you are fetching that value from excel. Print the value that you are fetching from excel to cross verify if right value is getting picked?