Initialise variables - string cutting off input?

Like (0) Share

Report

Posted on 18 Mar 2024 10:25:00 by smallzoo

I am running a flow when an email arrives, trying a different method

The email is as follows

Membership Number: 123456768
Application Reference: xxxxxxx-56a3-427f-b18d-21b261d5db77

Employer

Exists in CRM: True
Crm Id: xxxxxxx-2dae-e411-9401-005056a04b19
Employer Code: 123456
Name: a large company that is down the road from a smaller one

Address Line 1: the road
Address Line 2: the street
Address Line 3:
City: Romford
Country: United Kingdom
Post Code: AA01 xyz

The variable is just initialised as a string

yet looking at the input of the compose it has shorted the string

Membership Number: 123456768

Application Reference: xxxxxxx-56a3-427f-b18d-21b261d5db77

Employer

Exists in CRM: True

Crm Id: xxxxxxx-2dae-e411-9401-005056a04b19

Employer Code: 123456

Name: a large company that is down the road from a smaller one

So I am guessing the string is limiting to a certain number of characters

How do I increase the size

Cheers

I have the same question (0)

All responses (3)

Answers (0)

v-yetonggu-msft on 25 Mar 2024 at 06:23:54

Like (1)

Report
Re: Initialise variables - string cutting off input?

Hi @smallzoo ,

Please switch to classic designer.

Please add Email body into Html to Text.

Convert the body of an email from HTML format to text.

Of course, you can use expressions to get the Membership Number, and other fields in the email body.

I did a test for your reference.

In my scenario:

split(outputs('Html_to_text')?['body'],variables('ParseEmail'))[0]

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
smallzoo 26 on 18 Mar 2024 at 11:32:40

Like (1)

Report

Re: Initialise variables - string cutting off input?

Found the issue. I was (as per other suggestions on this site) using body preview for the compose but this cuts off the body text. However if I use Body instead then I cant use the split expressions as its all in html

It all works well if I use Body Preview except of course its cuts off the text !

e.g. Output from the email is

......<body lang="EN-GB" link="#0563C1" vlink="#954F72" style="word-wrap:break-word"><div class="WordSection1">Membership Number: 123456768 Application Reference: xxxxxxx-56a3-427f-b18d-21b261d5db77<h2>Employer</h2>Exists in CRM: True Crm Id: xxxxxxx-2dae-e411-9401-005056a04b19 Employer Code: 123456 Name: a large company that is down the road from a smaller oneAddress Line 1: the road Address Line 2: the street Address Line 3: City: Romford Country: United Kingdom Post Code: AA01 xyz<h2></body>....

so the input to the compose is

....<body lang="EN-GB" link="#0563C1" vlink="#954F72" style="word-wrap:break-word"><div class="WordSection1">Membership Number: 123456768 Application Reference: xxxxxxx-56a3-427f-b18d-21b261d5db77<h2>Employer</h2>Exists in CRM: True Crm Id: xxxxxxx-2dae-e411-9401-005056a04b19 Employer Code: 123456 Name: a large company that is down the road from a smaller oneAddress Line 1: the road Address Line 2: the street Address Line 3: City: Romford Country: United Kingdom Post Code: AA01 xyz<h2></body>....

when I look at the input / ouput of the add a row to excel its now weird
....
"table": "Email1",
"item/Membership Number": "<html><head>\r",
"item/Application Reference": "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><meta name=\"Generator\" content=\"Microsoft Word 15 (filtered medium)\"><style>\r",
"item/Exists in CRM": "@font-face\r",
"item/Crm Id": "\t{font-family:\"Cambria Math\"}\r",
"item/Employer Code": "@font-face\r",
"item/Name": "\t{font-family:Calibri}\r",
"item/Address Line 1": "p.MsoNormal, li.MsoNormal, div.MsoNormal\r",
"item/Address Line 2": "\t{margin:0cm;\r",
"item/Address Line 3": "\tfont-size:11.0pt;\r",
"item/City": "\tfont-family:\"Calibri\",sans-serif}\r",
"item/Country": "h2\r",
"item/Post Code": "\t{margin-right:0cm;\r"

which means I can no longer user
split(outputs('Compose'),variables('ParseEmail'))[0]
etc...

Was this reply helpful? Yes No
Tristan_D 388 on 18 Mar 2024 at 11:04:41

Like (0)

Report

Re: Initialise variables - string cutting off input?

Hi @smallzoo !

I just ran some tests and I can't reproduce the error :

Any chance for you to check if the variable is properly initialized ?

Let me know.

T

Was this reply helpful? Yes No