I am building a Flow with Outlook as the trigger - i need to grab the subject and remove part of it.
the email subject will be somehting like "SM Trigger :123" and it will always start with "SM Trigger:". I need to use the bit after (in this case 123) as the file name to save it.
any help on how to grab just the bit after the ":" (e.g. 123) would be much appreciated
I'm thinking either a last(split( or replace( but i cant quite figure it out.
thanks
Stephen
Solved! Go to Solution.
Hi @StephenM,
Please take the following flow configuration for a reference.
I used actions initialize variable and Set variable in the flow.
The function used in the Compose action is:
split(triggerBody()?['Subject'],':')
The function used in the Set variable action is:
outputs('Compose')?[1]
When a new email with the subject “SM Trigger: test123”arrives, the flow works fine and it returns “test123” after the “:”, please check the following screenshot:
Best regards,
Mabel Mao
Hi @StephenM,
Please take the following flow configuration for a reference.
I used actions initialize variable and Set variable in the flow.
The function used in the Compose action is:
split(triggerBody()?['Subject'],':')
The function used in the Set variable action is:
outputs('Compose')?[1]
When a new email with the subject “SM Trigger: test123”arrives, the flow works fine and it returns “test123” after the “:”, please check the following screenshot:
Best regards,
Mabel Mao
This answer is most helpful. Thank you! Another question related to this topic: How would you get the first two words in an outlook subject?
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
39 | |
36 | |
34 | |
31 | |
27 |
User | Count |
---|---|
44 | |
36 | |
33 | |
24 | |
22 |