Hi, Is there a way to use values from a split list\array as the source of a choice component? I currently don’t have the option to choose it. To be more specific this is not a multiple relation. This is generated from split text. all the data is stored in one row, not in a column.

Something like this may help: [image] fishbaguette_breadbasket Transpose Columns to an Inline List: The Miracle Method Community Resources I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRAC…

Choices need to come from multiple rows. You can’t build them based on a single row.

I see, Any ideas how It can be done ? I need to be able to choose values from split text

Are the values consistent? Meaning, are there a set list of possible choices, or can they be completely random? What I’m getting at, is that you could have a separate table that contains all of the possible choices for everything (one per row). Then you could use your split array to create a rela…

That would have been my next suggestion if the possible choices are random. :wink:

Yeah, then @Robert_Petitto ’s method could be your best option. I think a separate table with the max number of rows (choices) you would possibly have, then pass in you delimited list through an action and have the table transpose everything to separate rows. Using a user specific column to receive…

Prefect, it really worked like magic. I love it! Thanks [image]

Choice Component using split list or array

Ask for Help

Robert_Petitto March 12, 2022, 6:23pm 5

Something like this may help:

Topic		Replies	Views
Need data from split to be used in choice Ask for Help	4	51	April 16, 2025
Use comma-separated values as source for Choice? Ask for Help choice	10	695	February 15, 2024
Choice items from split text items on a form Ask for Help	7	278	March 8, 2023
Filtering in-line list dynamically with choice component Ask for Help	14	320	February 15, 2023
Choice items from split text items Ask for Help	15	1638	May 5, 2022

Choice Component using split list or array

Related topics