Expressions Appian Interview Questions

Junior Level Interview Questions

Interview Questions (25)

Sorted by: Recently AddedView All Categories

When extracting data from a PDF, the date is returned as a string, for example, "May 12th 2026" or "Sep 4th 2026". However, the corresponding field in the database is of type Date, so passing the string directly will not work.How would you convert this extracted string into a valid Appian Date before writing it to the database?

I would use an expression rule to convert the extracted date string into an Appian Date before passing it to the database.Take "May 12th 2026" as the extracted value. The rule spli...

A UAT user shares a production error screenshot displaying the generic message: "The system has encountered a problem. Contact your administrator." It includes an error number (e.g., 954c8:bb743). You do not have access to production screen or data access, but you do have access to the Development environment and the production server logs. How would you debug and resolve this issue?

Locate the Root Cause in the LogsAnalyze stdout Logs:I’d start with tomcat-stdOut.log on the production server. I’d look for the time of the error and check whether the stack trace...

Given a string, write a program to count the frequency of each word and display the word along with its count.Input: "Hello, test string, test"Output: Hello - 1test - 2string - 1

Code:a!localVariables( local!data : "Hello, test string, test", local!data1: split(local!data," "), local!uniqData: union(local!data1,local!data1), a!forEach( items: local!u...

In Appian, Write an expression to check whether given string is a Palindrome or Not ?

A palindrome reads the same forward and backward. MADAM, LEVEL, and 12321 are palindromes, and HELLO is not. In Appian you can check this by splitting the string into characters wi...

In Appian, Find vowels in the given array using expression rule. Expected output : { { word: "Apple", vowels: {"A","e"} }, { word: "Sky", vowels: {} }, { word: "Orange", vowels: {"O","a","e"} }, { word: "Fly", vowels: {} }}

a!localVariables( local!words: { "Apple", "Sky", "Orange", "Fly" }, a!forEach( items: local!words, expression: a!localVariables( local!word: fv!item, { wor...

In Appian, write a expression to remove every "AB" from each string, wherever it appearsExample:Input: {"ABHello", "HelloABWorld", "WorldAB", "ABCABD"}Output: {"Hello", "HelloWorld", "World", "CD"}Each value starts with "AB", and the goal is to remove this prefix from every string.

Solution 1: substitute()substitute(text, find, replace_with) swaps part of a string for another string, and the Appian community points to it as the replace-all equivalent.a!localV...

Difference between now() and today() in Appian ?

The two functions differ in whether they include a time, what data type they return, and how they relate to the time zone.now():now() returns the current date and time as a DateTim...

Expression based hands on a) Given 4 dictionaries of the students data with id, name and city, Asked me to remove the students which belongs to city Pune b) Update dict data, Change city name Mumbai to city name Bangalore Sample Data: local!students: { a!map(id: 1, name: "John", city: "Pune"), a!map(id: 2, name: "Sam", city: "Mumbai"), a!map(id: 3, name: "Ravi", city: "Pune"), a!map(id: 4, name: "Anu", city: "Delhi") }

a) Solution :a!localVariables( local!students: { a!map(id: 1, name: "John", city: "Pune"), a!map(id: 2, name: "Sam", city: "Mumbai"), a!map(id: 3, name: "Ravi", city: "Pu...

What is decision object in Appian and how it is used?

In Appian, a Decision Object implements business rules as a decision table. It evaluates several conditions and returns the matching result from predefined rules.Each column is an ...

How do you print the number between 1300 and 1600 in Appian?

Solution 1:This expression builds a list of the integers from 1301 to 1599 using a!localVariables(), enumerate(), and a!forEach().Appian Code:a!localVariables( local!initialValue:...

How do you generate all numbers divisible by 13 between 1 and 100 in Appian?

Appian Code:reject( fn!isnull, a!forEach( items: enumerate(100) + 1, expression: { if(mod(fv!item, 13) = 0, fv!item, null()) } ))ExplanationAbove appian expression returns...

How will you convert a given date in "MMM-DD-YYYY " string format ? Example : if date is "10/8/2025" convert date into the "Oct-08-2025"

Using text() function in the appian we can convert any give date into text format which we wantCode:text(now(),"mmm-dd-yyyy")Output:"Dec-20-2025"(Text)ExplanationThis code converts...

Find the duplicate words from the paragraph in Appian Input - A big buck bucket over the big bug bucket Output- big bucket

You can find duplicate words in an Appian expression with split(), lower(), union(), and wherecontains(). Split the sentence into words, build a list of the unique ones, count how ...

In appian, given a "n" number as input write a code to print numbers {n, n-1.....1} in reverse order. Example: For input ri!n = 5, output should be {5, 4, 3, 2, 1} shouldn't include zero and numbers should be reverse

Approach 1: First enumeration numbers and reversing it using reverse function.Codereverse(enumerate(ri!n) + 1)Output{5,4,3,2,1}ExplanationAbove Code returns the whole numbers from ...

In Appian, write an expression rule to find duplicate values from an integer array. Input: { 1, 2, 3, 1, 4, 8, 9, 4, 3 }, Expected Output: {1,3,4}.

We can use a!forEach(), wherecontains(), count(), and union() to identify the duplicates element in Appain in a given array.Appian codea!localVariables( local!data: { 1, 2, 3, 1,...

Using Appian expressions, how would you generate a numeric triangle pattern?

You can nest one a!forEach() inside another to print patterns with several rows. Appian Codea!forEach( items: enumerate(5) + 1, expression: joinarray( a!forEach( items: e...

How can you dynamically display the last 5 years in Appian including current year? Example : If current year is 2025 , need generate list starting from the current yearOutput : {2025, 2024, 2023, 2022, 2021}

In Appian, we can achieve this is multiple ways. I am showing two approaches , first approach is the most commonly used by the appian developer. Second approach is more efficient ...

How can we split a comma-separated string fetched from the database (e.g : "Java,Python,SAIL,Dart") into a list and display it as a dropdown in an Appian interface?

Will use the split function to divide string to list a!localVariables( local!data: "Java,Python,Sail,Dart", split(local!data, ","))OutputSave this rule and call this interface:Fi...

#sailcoding#interface

How do you remove duplicate values in an array in Appian ?

Will use union() to remove the duplicate elementsCode:a!localVariables( local!users: { "Naruto", "Sasuke", "Itachi", "Naruto", "Madhara", "Itachi" }, union(loc...

How do you compare two text values in Appian so that the comparison is case sensitive? For example, comparing "ram07m" with "Ram07m" should return false.

In Appian, using equal to "=" for comparison is not case-sensitive. For instant, if you are comparing usernames which has name "ram" and "Ram" Appian always treat both values are s...

What is the difference between the len(), count(), and length() functions in Appian, and when should each be used?

len(), length(), and count() look similar because they all return a size. They work on different things, though: len() takes text, while length() and count() take lists.1. len(): c...

#sailcoding#function#coding

In Appian, how would you generate a list of numbers from 1 to 500, and then display only every 100th number (i.e., 100, 200, 300, 400, 500) from that list using Appian expressions?

In Appian , we can use enumerate() we generate numbers and using mod we check whether number divisible by 100 and can achieved 100th number (i.e., 100, 200, 300, 400, 500) resultSt...

You are given a custom list of maps in Appian, where each map contains fields like name and id. Some of the name values are either null or empty strings. How would you remove the entries that have a null or empty name field using Appian expressions?Input:{ a!map(id: 1, name: "AppianVerse"), a!map(id: 2, name: "Appian"), a!map(id: 3, name: null()), a!map(id: 4, name: "Java"), a!map(id: 5, name: null()), a!map(id: 6, name: "flutter"), a!map(id: 7, name: ""), a!map(id: 8, name: "") }Output:{a!map(id: 1, name: "AppianVerse"), a!map(id: 2, name: "Appian"), a!map(id: 4, name: "Java"), a!map(id: 6, name: "flutter")}

In Appian, you can remove employee records with a null or empty name by looping over the list with a!forEach(), checking each name with a!isNotNullOrEmpty(), and dropping the lefto...

In Appian, suppose you have a list of a!map objects with fields name and id. How can you sort this list alphabetically by the name field?

In Appian, we can use todatasubset() with a!pagingInfo() and a!sortInfo() to sort the list.Appian Expressiona!localVariables( local!data: { a!map(id: 1, name: "Interface"), ...

JuniorCommonFrequently Asked

Expressions

Given an array with null values, how would you return a new array without any nulls in Appian?

Use the reject function to filter out all null values from the array.Code:a!localVariables( local!data: { 1, null, 6, 8, null, 19, 30, null }, reject(fn!isnull, local!data))Outpu...

Loading questions...