I am trying to concatenate a designator field that combines my autonumbered index field with the first 3 characters of my group field

Index field automatically incremented current Highest index +1 I have another field that needs to Join the first 3 characters of my group field with the index field

example Index: 1008 Group: ABM Support Designator: (Desired result) 1008ABM

I get an error in the InfoPath form when I try to use: concatenate(LEFT(Group,3), Index)

Expected value type: )

Actual value: , concatenate(LEFT(../my:Group,3)-->,<-- ../my:Index)

I have two Items I need to combine as a Designator for a SharePoint list. I have been able to auto increment the Index number, and I need to combine the index and first 3 characters of the group field to create the designator. I realize now I cannot use a concatenate string i.e. concatenate(LEFT(Group,3), Index). The problem lies that there are no common consistent characters to set a substring statement up. I was thinking to Add a default space at the beginning of the input and use that but not really sure how to go about that. Please advise if that would work and how to go about it.

1 Answer 1


Concat(Substring(1,3),Index) worked I was using wrong place holder (0,3)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.