Subject: For Each Row, use all column Values before moving onto next Row until row is empty
Hello - I’m a super newbie and I’m lost as heck. I’ve read through this forum in hope of finding help but I think I’m too slow to understand it all. PLEASE HELP IF you can.
I have an .xlsx containing 4 rows, representing logins for 4 different blogs. Each row contains 4 related Columns: BlogUsername, BlogPW, BlogTitle, STATUS
BlogUsername | BlogPW | BlogTitle | STATUS
1Username | pw1 | Blog Title1 | New
2Username | pw2 | Blog Title2 | New
3Username | pw3 | Blog Title3 | New
4Username | pw4 | Blog Title4 | Old
How do I tell UIpath to sign into each account by entering each row’s respective column values? Basically I need UIpath to look up the value of each row’s columns and sign in and sign out of a blog login page like tumblr’s.
Based on values in the “STATUS” column, how do I tell UIpath to only sign into blogs whose STATUS is “New”? Meaning how do I tell UIpath to read each row’s STATUS column and look for only those with “New” value? From the example, there are 3 blogs s to log into, how do I tell UIpath to log into each of these blogs?
For 1 & 2, UIpath needs to look through all rows where the first column “BlogUsername” is not blank.
I know there are some threads on this already but they honestly don’t much sense to me. Please help and share a quick example if you please can.