Having an issue with Split Function

[Anonymous]

The flow should take an email submission from a form and create an event.

I have the date/times all working. I am just trying to get the subject title working and I can't figure out why.

 

I am converting the email body from html to plain text, and then into 'Compose'.

'Event Name (Cut Text After)' is removing all text after the event name successfully.

'Event Name (Cut Text Before)' should be removing all text before the event name, but does not appear to be finding the delineator.

Any help would be very appreciated.

[KvB1]

In short, you want to end up with

?

[Anonymous]

Yes. That's correct.

I have fixed that issue by rewording "Name of Event/Project" in my form to "Event Name".

However, the same issue is now occurring in the 'Start Time' function. 'Start time (Cut Text After)' function is: first(split(outputs('Start_Time_(Cut_Text_Before)'),'Finish Time')). 

It is searching for 'Finish Time' then removing that and everything after that, leaving only the actual time.

The Raw Output:

It seems that the "Html to text" is adding '/n' into the raw text which is throwing off the split() function.
Html to text raw output below:

[KvB1]

I can imagine that this will happen

The safe thing would be to use the output of the html to text action as a base for your split functions, rather than the content of the mail

[Anonymous · Accepted solution]

Thanks for your thoughts. I am using the html to text output as the base, just getting the line space in html changed to a /n in the code which throws off the split functions.

I did some forum reading and found someone else having the same issue. It's a bit of a silly workaround but having a compose containing this fixed the issue:

uriComponentToString(replace(uriComponent(body('Html_to_text')), '%0A', ''))

It takes the 'html to text' output and converts it to URI encoded, which is code friendly and changes /n (Which is new line) into %0A, which is URI encoded for means news line. It then replaces '%0A' with ' '.

Taking the output of that function into all of my other functions fixes all issues i was having.