Outlook - Filter emails based on subject date

[Dinesh_Babu_S]

Hello all!
I am trying to get attachments which has subject “SEW_PaymentList-dd/mm/yyyy”( where where date keeps changing).

How to download attachments which has current date in subject.

[Marius_Puscasu]

Hi @Dinesh_Babu_S ,

Please try to add Convert.ToDateTime(now).ToString("dd/mm/yyyy”) within the Filter option from the Get Outlook Mail Messages activity

Best regards,
Marius

[Dinesh_Babu_S]

Hi Marius.

I tried the above code, but getting ERROR:Get Outlook Mail Messages: Condition is not valid.

[Pradeep_Shiv]

“[Subject]=‘SEW_PaymentList-dd/mm/yyyy’”

try this filter
@Dinesh_Babu_S

[jack.chan]

put this string in the filter field. This way it can filter by the subject

"@SQL=urn:schemas:httpmail:subject like 'SEW_PaymentList-" + now.ToString("dd/MM/yyyy") + "%'"

[Dinesh_Babu_S]

Hi pradeep.
I tried the above code but getting error in for each .
For Each: Object reference not set to an instance of an object.

[Dinesh_Babu_S]

Hi jack.

I tried the above code but getting error in for each .
For Each: Object reference not set to an instance of an object.

[jack.chan]

can you upload your sequence here

[Dinesh_Babu_S]

Sure.
Main.xaml (6.0 KB)

[jack.chan]

This should be equal to Mymails, you forgot to fill in the output

[Dinesh_Babu_S]

Thank you. Its’s working fine now.
Could you please check this as well.

Invoke GetAppcredentials workflow: Object reference not set to an instance of an object

Hello jeevith, I tried the above steps. But still getting the error. I’ve attached the file. Could you please look into this?ACME.zip (1004.8 KB)

Sorry for the trouble.
Seems its working fine when others run it. But its throwing error in my system.