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:

Business Process Flows

All responses (4)

Answers (0)

shirokun on at

Like (1)

Report

Compose comments

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,
Expiscornovus 31,844 Most Valuable Professional on at

Like (1)

Report

Compose comments

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 (1)

Report

Compose comments

Hi Thank you so much for this.

here is the result:

and the output
Expiscornovus 31,844 Most Valuable Professional on at

Like (1)

Report
Compose comments

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

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