cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Trim function error

I have an error in trim expression. Could someone please help?

 

error.jpg

 

Annotation 2019-08-02 202326.jpg

 

and when I typed trim() in expression and came back to dynamic content I do not see my fields.

 

error1.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Trim function error

Posting Date is probably a DateTime Field and Trim only works with Text.  YOu could try changing your formula to 

Trim(formatDateTime(body('Get_items')?['Posting_Date']), 'D')


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
Dual Super User
Dual Super User

Re: Trim function error

Posting Date is probably a DateTime Field and Trim only works with Text.  YOu could try changing your formula to 

Trim(formatDateTime(body('Get_items')?['Posting_Date']), 'D')


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (6,692)