Hello -- I've created the beginning of the flow: the email populates into a folder in my inbox, and I've began on the next step.
This is what I have so far:
When a new email arrives
Inbox
To
From
etc..
Create Item
Site: Sharepoint site
List name
List item 1. substring(triggerBody()?['Subject'], 5, 4)
- which works^ - it returns the value I needed.
List item 2.
- I need to return the last element of the subject line but not sure how
Example Subject Line:
ABC: Jane D--3F (Frank)
I have successfully extracted information from list item 1. with the formula above.
What formula would I use to return (Frank) without paranthesis?
