none
SubString Error in Logic App - URGENT Please help RRS feed

  • Question

  • Hi,

    I am trying to "truncate" the LAB_LOC_CD String to 6 chars which is in an Array of Strings. I am using

    Substring(string(body('Parse_Json_2')?['externalCode']),0,5)

     

    and getting the following error:

    IInvalidTemplate. Unable to process template language expressions in action 'Append_to_array_variable' inputs at line '1' and column '2956': 'The template language function 'Substring' expects its first parameter 'string' to be a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#substring for usage details.'.
     
    mikekiser_0-1595954625512.png

     

     

    mikekiser_0-1595954347160.png

     

    Can someone please help? It is urgent that I get these strings correctly truncated.

    Thanks!
    Mike Kiser


    Mike Kiser

    Tuesday, July 28, 2020 5:45 PM