How to add veriable in query of get message activity in office 365

Help Activities
, ,
1

I am i a automation where i have to filter query to get mail depend on subject line.

but i want add veriable for subject line e.g contains (subject,‘project report no’+srt.number)

how should i write query?

2

Hi @Hemant_Deshmukh

You can try to write the query like this assuming srt.number is the variable

"contains(subject, 'project report no" + srt.number.toString + "')"
1 Like
Forum Engagement Daily Reports
3

Hi @Hemant_Deshmukh
In the Filter property of the activity you can pass this query
“[Subject] ‘%project report no " + srtNumber.ToString + "%’”

4

@Hemant_Deshmukh,

Try this filter query "subject has 'project report no "+srt.number+"'"

5

This is only for Classic Office 365 Scope activity. For Integration Service we have filter option like this.

This image shows the setup of an email filter in Microsoft Outlook 365 to retrieve emails from the Inbox folder based on a subject line that contains a dynamic value for a project report number. (Captioned by AI)
This image shows the setup of an email filter in Microsoft Outlook 365 to retrieve emails from the Inbox folder based on a subject line that contains a dynamic value for a project report number. (Captioned by AI)1354×884 44.9 KB

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.