dynamically select multiple values

[adampolcz]

hi Experts,

I have a workflow which creates a list of financial data in different periods - now from 2025.01 to 2025.09 ,like company code, product, period, to make it simple.

The user needs to select 2 periods from the whole, so the best solution would be that a list box or similar identifies the values or it is pre-written in a custom list.

I saw videos on how to select 1 item with text box and action tool connected to the filter tool but that's not enough for me. I need to understand how to select multiple values and as the year is always changing I have to select the whole "year.period" expression or to be able to build this from a period like "08" or "12' and so on.

My query has nothing to do with dates.

[KGT]

A couple of things.

• When using a custom list in a couple of the interface tools, the list will be NAME:VALUE, whereby NAME is the displayed name (e.g. Period08), and the VALUE is the value that is passed to the workflow (e.g. 2025.08, 2025.07, 2025.06).
• That pass-through can go to a formula and then you construct that into something that can be filtered. It doesn't necesarily have to go straight to the filter.
• The action tool, allows a little formula manipulation as well. (such as Left(DateTimeToday(),4) + "Right([#1],3) to add the current year to .09 or whatever was chosen for the period)

Above all though, this is something to remember, you can't compute things in the workflow to construct a list that is used in the interface tool. That list in the interface tool, will appear before any of the other tools on the canvas have run. (So, you can't get a list of unique periods from the file and use that to generate a drop-down, however, you can use a file in the dropdown).