Power Automate when a new email arrives Subject Filter Wildcard

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community,

I want to apply a subject filter with wildcard characters, I have tried the below expression.

@startswith(triggerOutputs()?['body/subject'], 'Doc*')

It is taking the 'Doc*' as a string value and not taking '*' as a wildcard character.

Is there any expression available for wildcard matching in Power Automate flow?

Thanks,

@Anonymous

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ，

There is no wildcard character for startswith , you could use this formula directly:

@startswith(triggerOutputs()?['body/subject'], 'Doc')

If you wish to limit the subject to 4 characters, you could try:

@and( startswith(triggerOutputs()?['body/subject'], 'Doc'), equals(length(triggerOutputs()?['body/subject']),4) )

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Bof,
Thanks for your reply!
So you are coming to tell is no wildcard character only for startswith? So, can we use the Wildcard characters for string values like contains, not contains, endswith, and not endswith ??
Also, I make sure to try to limit the subject to the 4-character method that you suggested.

Thanks,
@Anonymous

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

In addition, you could also try regex.

https://andersjensen.org/how-to-use-regex-in-power-automate/

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

Power Automate string functions do not support wildcards.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you for clearing my doubts. @VictorIvanidze

Was this reply helpful? Yes No