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 II
Super User II

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 II
Super User II

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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (89,875)