Trying to automate an email body into new row in excel. (see image below). I would prefer the email body to be in a Table format, but I can't figure that out, either. I got this far with text, but now I'm stuck:
Date and Manager (the From email) populate correctly. Other fields populate correctly: Here's the Expression from the Program line: first(skip(split(first(split(body('Html_to_text'),'Program:')),'Unit or Region:'),1))
Here's the two I'm having trouble with:
Unit/Region: it will not populate with any data:
first(skip(split(first(split(body('Html_to_text'),'Unit/Region:')),': '),1))
Notes: it works, but also pulls all the email signature data as well. It needs to be in long text so Users can input anything, but it should not include the signature:
first(skip(split(body('Html_to_text'),'Notes: '),1))
I can't figure this out . . . Your assistance would be greatly appreciated!