Unanswered

Compose comments

(1) Share

Report

Posted on by shirokun

Hello!

I need help with a flow that reads incoming emails and updates the status and comments on a SharePoint list. The status is captured 100%, but the comments are not, and I don't know how to fix the function to make it work 100%.

Here is the flow and the function. The comments are always very similar, like: IPN666666 Call 1 13 March 2024 AP.

When I read the output from "HTML to text," one thing I notice is:

If the flow doesn't work, it shows: Comments:\n| IPN666666 Call 1 13 March 2024 AP|
If it does work, it shows: |\nComments: | IPN666666 Call 1 13 March 2024 AP|

Thank you!

I have tried removing the trim () but it now capture the entire email contents.

May be an image of ‎text that says '‎! InvalidTemplate Unable to process template language expressions in action Compose_comments inputs at line יס' and column ניס' 'The template language expression trim/split(splitloutputs(Html_to _text')? ['body] Comments ניזדן ננס(' cannot be evaluated because array index יוי is outside bounds (0, 0) of array, Please see https://ka.ms/logicexprssions for usage details.'.‎'‎

Categories:

Building flows

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Can you try the below expression with a replace function instead?

split(split(replace(outputs('Html_to_text')?['Body'], '\n', ' '), 'Comments: |')[1], '|')[0]
shirokun on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Thank you so much for this.

here is the result:

and the output
Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

That means it cannot find the 'Comments: |' part in your Body field?

Have you checked the Body field of that output? In the screenshot I only see the statusCode and headers, I don't see a Body field. Can you share that part of the screenshot as well?
shirokun on at

Like
a
(1)

Report
Copy link

Link copied!

hello yes! please see below. on the body it looks like it did find the "comment: |"

EXTERNAL SENDER. Does this email look suspicious? Click on Report Message/Phish
Alert in the top right of your Outlook toolbar. Do not open attachments or click
on links.

--------------------------------------------------------------------------------

Hello,

An update has been made: Rec ID: |1324351| Gender: |F|

MOB: |3/11/2026| Status: |Completed| Comments:
|IPN123552 NGIM 22 Jul 2024| ID: |167| Thank you,