Skip to main content

Notifications

Power Automate - General Discussion
Answered

Invalid append to string

(0) ShareShare
ReportReport
Posted on by 49

Hi Team, 

 

I'm getting the error below, but no idea how to solve it.

Error detail as below : 

Unable to process template language expressions in action 'Append_to_string_variable' inputs at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Marthini_06_0-1691718707661.png

 

Marthini_06_1-1691718761455.png

 

Marthini_06_2-1691718780975.png

 

 

 

Categories:
  • trice602 Profile Picture
    trice602 11,541 on at
    Re: Invalid append to string

    Nice!  There is never a better feeling than getting a flow to run successfully! Always glad to help! Tom

  • Marthini_06 Profile Picture
    Marthini_06 49 on at
    Re: Invalid append to string

    Hi @trice602 ,

     

    Thank you so much. It works as expected !

  • Verified answer
    trice602 Profile Picture
    trice602 11,541 on at
    Re: Invalid append to string

    Hi @Marthini_06 ,

     

    Yeah so your formatDateTime() expression is a date type and you need to convert to a string.  Please wrap your existing formatDateTime expression in a string() such as string(formatDateTime(your_code)).  This will convert that value to a string and you can keep going.  Please mark as a solution if this help!  Always glad to help! Tom

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard