Trim Error on Dynamic Content from Excel

[bsmith736464]

I am pulling values from rows in Excel and trying to run the trim function on the values to make sure it is correct but I keep getting the error of:

"InvalidTemplate. Unable to process template language expressions in action 'Compose_2' inputs at line '1' and column '2202': 'The provided parameters for template language function 'trim' are not valid.'."

My trim expression is: trim(body('List_rows_present_in_a_table')?['value'])

Any help would be greatly appreciated.

[fchopo · Accepted solution]

Hello @bsmith736464 

Insid the compose action, you should insert an expression like the following: 

trim(items('Apply_to_each')?['Title'])

In this example I apply the trim to a column called Title, so you should replace it by the column name you want to be trimmed.

Hope it helps!

Ferran