Hi,
Im trying to remove all irrelevant data and extract multiple IDs out of an email body to use the IDs to change a sharepoint list.
The emails recieved will contain multiple instances of CrateID:RZCS9999 (and various others i.e CrateID:RZCS9998)
currently however the filter array creates the following from the emails
[
"RZCS9809 ",
"RZCS9999 ",
"RZCS9998 "
]
I cannot get rid of the spaces at the end of the ID's and i can't figure out how to use each individual?
(The following is my composes)
RemoveEmptyLines =
replace(outputs('HTMLInsideCompose'),outputs('EmptyLines'),'')
TrimCompose
substring(outputs('RemoveEmptyLines'),0,sub(length(outputs('RemoveEmptyLines')),1))
AllOnANewLine
split(outputs('RemoveEmptyLines'),'CrateID:')
And the Filter Array is supposed to seperate

