topic Re: How do i perform a formula on a list input? in Workato Pros Discussion Board

How do i perform a formula on a list input?

jarh15 — Thu, 08 May 2025 04:56:26 GMT

Hi,

I am trying to see if a list is present and if it's not, then use another list. I'm using this in a list input step for a modal. I would use a formula but there is no button for formula mode on list input. See screenshots

Re: How do i perform a formula on a list input?

1dheeraj2 — Thu, 08 May 2025 08:03:02 GMT

Hi @jarh15

As far as i know, list input fields don't support formula mode functionality.

Since you're querying the same sheet with different values, I assume you're working with consistent column structures.

I would use below two approach ( if columns are same )

Using Collections:

Collections support formula mode
You can check for data existence using expressions
Query data from collection. Use Query output in your slack action.
Drawback: Requires 2 additional tasks in your flow

2. Python Connector Approach:

Create a custom Python script to handle the logic.
Performs all necessary checks internally
Returns a consolidated output list
Drawback: Requires basic Python knowledge

Please share if you discover an even better solution, as this is a common scenario many of us encounter.

Re: How do i perform a formula on a list input?

Obugari — Thu, 31 Jul 2025 13:11:20 GMT

Hi @jarh15 ,

In workato for input list there is no formula mode available. but you can try below options
1.Before slack step you can add logger step or variable and apply formula mode there if present or not
2. You can try with query list by workato . It is also best solution but sometimes (we need to use insert rows if required based on condition)

Thankyou