Hi ,
this is a continuation of yesterday's post.
what I'm trying to do is basically extract the Time and Date for an email that comes with two varying key phrases.
- Proposed Start Time or Proposed Start Date
- Proposed End Time or Proposed End Date
@Paulie78kindly helped with an awesome expression. So now, my flow works perfectly for both phrases (Proposed Start Time or Proposed Start Date) with this expression
if
(
greater(indexOf( outputs('Html_to_text')?['body'], 'Proposed Start Time:'), 0),
last(split(first(split(outputs('Html_to_text')?['body'],'MST')),'Proposed Start Time:')),
if
(
greater(indexOf( outputs('Html_to_text')?['body'], 'Proposed Start Date:'), 0),
last(split(first(split(outputs('Html_to_text')?['body'],'MST')),'Proposed Start Date:')),
'Not Found'
)
)
however, for the Proposed End Time or Proposed End date, I can't get to work
I'm using the following expression
if
(
greater(indexOf( outputs('Html_to_text')?['body'], 'Proposed End Time:'), 0),
last(split(first(split(outputs('Html_to_text')?['body'],'MST')),'Proposed End Time:')),
if
(
greater(indexOf( outputs('Html_to_text')?['body'], 'Proposed End Date:'), 0),
last(split(first(split(outputs('Html_to_text')?['body'],'MST')),'Proposed End Date:')),
'Not Found'
)
)
When an email with Proposed End Time comes I get this
then when an email with Proposed End Date I get Not Found
I know there's gotta be something incorrect with my expression, I just can't quite figure out what it is.
Any help with be greatly appreciated


Report
All responses (
Answers (