How do i perform a formula on a list input?

[jarh15]

 

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

[1dheeraj2 · Accepted solution]

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 )

1. 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.

[Obugari]

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