โ05-07-2025 09:55 PM - edited โ05-07-2025 09:56 PM
โ
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
Solved! Go to Solution.
โ05-07-2025 10:34 PM - edited โ05-08-2025 01:03 AM
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 )
Please share if you discover an even better solution, as this is a common scenario many of us encounter.
โ05-07-2025 10:34 PM - edited โ05-08-2025 01:03 AM
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 )
Please share if you discover an even better solution, as this is a common scenario many of us encounter.
โ07-31-2025 06:11 AM
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