Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
  • State Suggested Answer
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 7 subscribers
  • Views 2754 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

How to Replace Special Characters [ , ], " from a local variable result

mollyn126

Hi every one, 

I'm having a local variable that store data in a Json format then converted it into a type that Appian accepts:

a!fromJson(local!settings) 

and I get this as the result: 

Dictionary

    • name"Type"(Text)
      • value"["5"]"(Text)
        • valueDisplay""(Text)

          I want to get all the settings with value equals a particular ID, but it shows this error: Expression evaluation error at function 'wherecontains' [line 41]: Invalid types, can only act on data of the same type (Number (Integer), Any Type).

           index(local!settings, wherecontains(local!currentType.Id,local!settings),"value",null)

          I guess the issue is because value is now containing special characters. 

          Any one having a solution for this? 

          Thanks a lot in advance for your helps!

            Discussion posts and replies are publicly visible

          Parents Reply Children
          © 2026 Appian. All rights reserved.
          We want to hear from you! Submit a review on Gartner or G2.