How to pass email Id in Microsoft office 365 get mail activity

[Gayathri_Mk]

Hi team can anyone help me how to pass email I’d in Microsoft 0365 activity.
I am getting below error .
I will get multiples so I stored in array of string and spliting it with , current item.to string I used it’s not working.

Current item.tostring().trim() i used nothing is working

[Anil_G (Anil Gorthi)]

@Gayathri_Mk

May I know which firld are you trying to configure?

Is your currentitem string or object?

If in account field then string should work

Please show some screenshots or error message properly

Cheers

[Gayathri_Mk]

I am using current item

this is the query I am using

In email result I am not getting any value

[Anil_G (Anil Gorthi)]

@Gayathri_Mk

1. First remove the brackets they are not needed
2. Can you first check with hardcoding a value instead of currentitem just to test if filter is working

Cheers

[Gayathri_Mk]

I am getting data if i hardcode it.
If i pass the current item email result is empty and getting error not supported as you can see the screenshot i attached it earlier

Is it fault with the query written if yes can u pls provide me query how to write it

[Anil_G (Anil Gorthi)]

@Gayathri_Mk

Can you print the query that is created once…looks like there are some special charqcters or so

Cheers

[Gayathri_Mk]

“(from/emailAddress/address eq '” + currentItem.ToString().Trim() + “')”

[Anil_G (Anil Gorthi)]

@Gayathri_Mk

I see the wuery here…can you use a log message and check the value which is coming to make sure it is proper…looks like the query is coming in wrong

Cheers

[Gayathri_Mk]

even if pass the email id directly in email filed of getemail it throwing exception as attached screenshot

[Gayathri_Mk]

@Gayathri_Mk

“(from/emailAddress/address eq ‘” + currentItem.ToString().Trim() + “’)”

I’m using this query in Query field, and i’m getting email id as i mentioned in the in currentItem
this is the source where i took from

[Anil_G (Anil Gorthi)]

@Gayathri_Mk

1. First email ID first is to pass the uid or the unique email ID which is not the email address, so if you pass email address in email id field it would obviously throw error
2. Next for query what I am asking is to print the variable values to check if the query is looking proper or not, because as per error looks liek there are some special characters or so in the query

cheers

[Gayathri_Mk]

I have checked the email id coming in the query from locals, it is printing the value as mentioned in the foreach row of currentitem. please find the attachments for the same

@Yoichi @ppr @supermanPunch if u people can also involve and help me out to resolve this issue that would be a great help.

[supermanPunch (Arpan)]

Hi @Gayathri_Mk ,

So for summarising the steps tested so far, you have tested by hardcoding the email id value in the query and it did work but when you tried using the value from currentItem variable, it does not provide you with the result ?

@Anil_G

Next for query what I am asking is to print the variable values to check if the query is looking proper or not, because as per error looks liek there are some special characters or so in the query

If that is the case, could you use a Write Line activity and print the value of currentItem variable in it, make sure to double click on the value logged into the output panel and check the contents, if there are special hidden characters, we should be able to visualize it there.

[Gayathri_Mk]

no special characters are available in the current item I have check it.
If query is not correct can u help me with proper query.

my requirement is to check for bounced emails so I need to check for the emailID whether email has been delievered or not .
and second I need to download the attachment for the email Id provided

sample email image how I will get if I couldnt able to deliver it
can u help me with query if possible pls for both the scenarios.