Power Automate Community,
Good afternoon, I hope this is an easy answer but I have not been able to find an answer online yet. I have a flow where users send me a request for an approval. My flow works perfect except for the final Compose statement for some reason part of the comments that the clients are sending me are being cutoff. Below is my flow and expressions. It's the Compose 9 that is causing my issue:
Html to Text (Preview) - Content= </> Body
Compose - Entered a Blank Line
Compose 2 = Expression = split(outputs('Html_to_text')?['body'], outputs('Compose'))
Filter Array = From = Outputs 2 | Length = length(trim(item())) | is greater than | 0
Compose 3 = Expression = split(body('Filter_array')[2], ':')[1]
Compose 4 = Expression = split(body('Filter_array')[3], ':')[1]
Compose 5 = Expression = split(body('Filter_array')[4], ':')[1]
Compose 6 = Expression = split(body('Filter_array')[5], ':')[1]
Compose 7 = Expression = split(body('Filter_array')[6], ':')[1]
Compose 8 = Expression = split(body('Filter_array')[7], ':')[1]
Compose 9 = Expression = split(body('Filter_array')[8], ':')[1]
Excel = Add a row into a table
Location = OneDrive for Business
Document Library = OneDrive
File = My excel spreadsheet
Sample of What is submitted - An error with the input of the effective bill date caused customer to be incorrectly billed for data overage and undercharged for subscription charges. Please see attached doc on backup tab for credit calculation.
What’s coming through - An error with the input of the effective bill date caused customer to be
Any help/ direction would be greatly appreciated. Thanks in advance.
Owen
