Email validation - Find Valid and Invalid email address

Help Studio
1

I’m building an email address validation that checks to see if an email address is still active and it should get the validation result (Valid/invalid) to excel sheet.

The problem is i’m able to check each each records but i wasn’t able to print the result in excel. can anyone please help me?

1 Like
2

can i have sample excel that you using for validation and workflow aswell

1 Like
3

Validation
Validation476×1004 117 KB

I’m unauthorized to upload workflow as i’m new to uipath community

1 Like
4

https://www.verifyemailaddress.org/ this is the validation url

1 Like
5

you can have if condition then you can use assign activity row(“status”)=valid/invalid based on if condition

1 Like
6

I’m Actually new to Uipath, Can you please post the screenshot or xaml ?

1 Like
7

It’s actually putting the email address in the searchbar and getting the result, but i don’t know how to get the results in excel. can you please teach me how to write it in the same excel sheet?

I want the below marked value to be copied and pasted in the excel

Validation
Validation737×341 63.9 KB

1 Like
8

Please find below the xaml file and excel sheetEmail_Validation.xaml (12.6 KB)

Email_Validation_20.xlsx (8.6 KB)

1 Like
9

emailvalidation

i am getting this i’m not a robot button & also sometimes its asking for images to select i think its not possible.

Thanks

1 Like
10

It will ask for the first time only, If we proceed that once ,it will not ask again.

1 Like
11

I’m getting the data’s, can you please tell the steps to get it in the excel?

1 Like
12

1.please add one more column in excel as status.
2.if message is valid the use assign activity row(1)=“Valid” else row(1)=“Invalid”
3.out of the loop use write range activity and overwrite the dt to excel file.

1 Like
13

Validation
Validation1920×1080 247 KB
I’m getting the data showed in the screenshot

1 Like
14

use if activity with condition validation.tostring.tolower.contains(“not valid”) the update the row(1) = “invalid” else row(1)=“invalid”

1 Like
15

Email_Validation_28Apr2020.xaml (13.4 KB)

still not copying the data to excel, Can you please check the issue?

1 Like
16

@Steve_Smith you have not assigned the Validation data to the Datatable, Inside the For Each Row at the End, add the Assign Statement below :
row(1) = validation.ToString

Then in the Main Flowchart Create a New Sequence and Use Write Csv Activity to write the Updated Datatable to an Output File.

Connect the Sequence to the Previous Sequence

1 Like
17

Still its not fetching the data to excel. Email_Validation_28Apr2020.xaml (15.3 KB)

1 Like
18

@Steve_Smith You have used the datatable variable instead of Email variable, Use the Email variable in the Write CSV Activity

1 Like
19

That’s awesome.It worked. Thanks a lot. but its writing the data’s once the program complete, if its interrupt in the middle its not writing anything. it should write in the excel after every email check. any suggestions?

1 Like
20

@Steve_Smith What Kind Of Interruption :sweat_smile:

1 Like