Hi,
I am trying to make Email Validation Flow that will check if Email address is Invalid or Not.
if Email address is Valid I want to store them in 1 String Variable with separator semi colon “;”
Here is the Excel where I get all the emails.
Here is the structure of my workflow
expected output:
email1@gmail.com ; email2@gamail.com ; email3@gmail.com ; email4@gmail.com
Thank you in advance
-Vincent
Hi
You are almost done
Inside the IF activity in THEN block First use a assign activity Inside the IF condition
str_temp = strValidate.ToString
Str_temp is a string variable defined in variable panel which is of type string
Then inside the same THEN block use another assign activity
str_mailid = str_temp + “;”+ str_mailid
Where str_mailid is a string variable defined in Variable panel of type string with default value as String.Empty
Now str_mailid will have all the mail I’d with ; as separator
Hope this would help you resolve this
Cheers @Vincent_Nuestro
Hello @Vincent_Nuestro
Here you go
Below is the workflow for the same:-
Main.xaml (16.8 KB)
Sample.xlsx (9.3 KB)
Output:-
Mark as a solution and like it if this helps you
Happy Automation
Best Regards
Er Pratik Wavhal
1 Like
hi @Pratik_Wavhal can i have screenshot instead?
i cant open the file
Hi @Vincent_Nuestro
Did this method help in this scenario
hi @Palaniyappan
no, it only gives me 1 email per loop
Well there is one more option to handle this
Inside the then block use a ADD TO COLLECTIONS activity where mention in property panel as
Collections - list_mailid
Item - strValidate.ToString
Where list_mailid is a variable of type system.Collections.Generic.List(of String) defined in the variable panel with default value as New List(Of String)
after the loop use a assign activity like this
str_finalmailid = String.Join(“;”,list_mailid.ToArray())
A simple approach to solve this
Cheers @Vincent_Nuestro
1 Like
Palaniyappan:
New List(Of String)
I put the list of String above for each loop
1 Like
thank you, it works now:) @Palaniyappan
1 Like
Hello @Vincent_Nuestro
Below are the screenshots of the workflow:-
As @Palaniyappan told you the logic which you have now marked as solved, the same I had implemented.
Happy Automation
Best Regards
Er Pratik Wavhal
2 Likes
hi @Pratik_Wavhal and @Palaniyappan thank you so much for your help
1 Like
Glad @Vincent_Nuestro
Happy automation
system
(system)
Closed
October 20, 2021, 1:17pm
14
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.