Answered

Trigger Condition that filters for a 10-digit integer?

(0) Share

Report

Posted on by MarcusD1

271

I'm building a Flow that triggers when an email is received but is sent as a SMS or MMS from a phone. The sender (From) appears as a 10-digit number plus the phone carrier code, e.g. "2025551212@vtext.com"

I want to add a trigger condition that only launches the Flow when the sender includes a 10-digit integer (but not a specific set of numbers). I'm thinking it should look something like

@contains(triggerBody()?['From'], XXXXX)

but I have no idea how to characterize a 10-digit integer?

Any suggestions?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @MarcusD1

With the following expression you could check:

1) If From field length before '@' is 10 digits.

2) If this 10 digits are numbers, or at least, could be converted to integer value.

The expression is the following:

if(equals(length(substring(triggerOutputs()?['body/from'],0,indexOf(triggerOutputs()?['body/from'],'@'))),10),isInt(string(substring(triggerOutputs()?['body/from'],0,indexOf(triggerOutputs()?['body/from'],'@')))),false)

a) Get 10 first digits before '@':

substring(triggerOutputs()?['body/from'],0,indexOf(triggerOutputs()?['body/from'],'@'))

b) Check if it is 10 digits:

equals(length(substring(triggerOutputs()?['body/from'],0,indexOf(triggerOutputs()?['body/from'],'@'))),10)

c) Check if it's an integer:

isInt(string(substring(triggerOutputs()?['body/from'],0,indexOf(triggerOutputs()?['body/from'],'@'))))

Mixing all expressions you can get that.

Hope that helps!

Ferran

Was this reply helpful? Yes No
Verified answer

Ellis Karim 12,024 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @MarcusD1 ,

Extending what @fchopo has provided, you could also try the following trigger condition:

@and(equals(length(first(split(triggerBody()?['From'], '@'))),10), isInt(first(split(triggerBody()?['From'], '@'))))

Get the text before the @ symbol in the From address,

the length of the string must be 10 characters

must be an Integer.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
MarcusD1 271 on at

Like (0)

Report
Copy link

Link copied!

Thank you @ekarim2020 and @fchopo ! Both solutions worked.

Was this reply helpful? Yes No