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.