cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bsmith736464
Helper I
Helper I

Trim Error on Dynamic Content from Excel

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.

 

Screen Shot 2020-02-16 at 9.15.00 AM.png

1 ACCEPTED SOLUTION

Accepted Solutions
fchopo
Super User
Super User

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
Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

1 REPLY 1
fchopo
Super User
Super User

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
Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,880)