I have a flow when an email message is flagged sends an email using "FROM" in the subject. Something like "FROM"'s message was flagged". The "FROM" always returns a e-mail address "name.surname@domain.com" I though I could easily shorten it by using Substring("FROM", 1, indexOf("FROM","@")) but some how it is not that simple and I have no idea why it is returning an Expression is invalid.
When I insert the "FROM"on the expression it gets automatically transformed in "triggerOutputs()?['body/from']"
substring(triggerOutputs()?['body/from'],1,indexOf(triggerOutputs()?['body/from'],"."))
What am i doing wrong?
N
