Power Platform Community Forum Thread Details

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

Categories:

Extract Multiple ID's out of Email Body