web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate Power Automate when a ...

Power Automate

Answered

Power Automate when a new email arrives Subject Filter Wildcard

(0) Share

Report

Report

Posted on by Community Power Pla...

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:

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (2)

Verified answer

v-bofeng-msft 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... 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 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... on at

Like (0)

Report
Copy link

Link copied!

Thank you for clearing my doubts. @VictorIvanidze

Was this reply helpful? Yes No

Join the conversation