Parse the subject line in an email using power automate

%3CLINGO-SUB%20id%3D%22lingo-sub-1873552%22%20slang%3D%22en-US%22%3EParse%20the%20subject%20line%20in%20an%20email%20using%20power%20automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1873552%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20-%20I%20am%20trying%20parse%20the%20subject%20in%20a%20new%20email%20using%20power%20automate.%26nbsp%3B%20The%20subject%20would%20look%20something%20like%20123456-7890.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20parse%20the%20string%20before%20the%20dash%20and%20after%20the%20dash%20to%20load%20into%202%20separate%20fields%20in%20a%20sharepoint%20list%20item.%26nbsp%3B%20I%20was%20trying%20something%20like%20this%2C%20but%20to%20no%20avail....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3Esplit(triggerBody()%3F%5B%3C%2FSPAN%3E%3CSPAN%3E'Subject'%3C%2FSPAN%3E%3CSPAN%3E%5D%2C%3C%2FSPAN%3E%3CSPAN%3E'-'%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1873552%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hello - I am trying parse the subject in a new email using power automate.  The subject would look something like 123456-7890.

 

I need to parse the string before the dash and after the dash to load into 2 separate fields in a sharepoint list item.  I was trying something like this, but to no avail....

 

split(triggerBody()?['Subject'],'-')
1 Reply

I was able to resolve this.@rbutgins21