Save sender email and check in File excel

Hello friends,
(@Rammohan91, @balupad14, @ClaytonM, @vvaidya, @Florent_Salendres )
I need to get all emails coming from Outlook, save the sender, check if the sender email is present in an Excel file.

File.xlsx (8.2 KB)
I need to check if the email sender is present in the column “Rif. recapito”, if yes get the corresponding value in the column “Codice rete”.

Can you please help me in creating a workflow?
Thank you,
Cami

1 Like

Hi,
Once you receive the list(mailmessage) use a for loop and inside for loop send the from address to a table created using build datatable activity,

And then you can use select query and check using if statement weater the value from address is there or not.
Please use this logic and build your workflow.

Let us know if this helps,
Regards,
Pavan H

2 Likes

Thank you so much @pavanh003.

Can you please help me in creating the workflow for the part:
And then you can use select query and check using if statement weater the value from address is there or not.

Thank you so much.,
Cami :slight_smile:

1 Like

Hi @CamiCat,

Step1:use get Outlook mail and get all the mail
Step2:loop through all the mails
Step3:assign strSeneder=mail.fromaddress
Step4:read excel file
Step5:drFilteredResult=DT.select("[Rid.recapito]="’"+strSeneder.tostring+"’"")
Step6: result will be of type array of data row.
Step7:check count of drFilteredResult(valadiation)
Step8:convert to data table
dtFilteredReult=drFilteredResult.copydatatable()
Step9:write to excel file

2 Likes

Hello @Gouda_6,

I’m having trouble in performing and developing this workflow.
Can you please help me in developing it?
CAn you lplease provide me an example of workflow?
Thank you so much,
Cami :slight_smile:

Hello @Gouda_6,

I’m having trouble in performing and developing this workflow.
Can you please help me in developing it?
CAn you lplease provide me an example of workflow?
Thank you so much,
Cami :slight_smile:

Hi @CamiCat

As you have passed the advanced course, I am sure that you can develop this flow, as it is an easy one. If you get stuck, please come back with what you have done, what is the error and where you are stuck.

1 Like

Hi @CamiCat,

Please find the Xaml file
Main.xaml (7.8 KB)

2 Likes

Thank you so so much @Gouda_6.
I’ll try and let you know very soon :slight_smile:

Sign Up Log In