Storing checkbox values as a string

(0) Share

Report

Posted on by elseb

774 Moderator

Hi,

I'm trying to find a way to limit the number of columns in my sp list. I have 5 questions (y/n) which are answered by ticking the checkbox control, I was thinking about collecting all the results and putting it in a text column as a string with delimiters, the problem starts when I think about extracting the result back to the form, I thought I could use Split() for that but I'm not sure how to extract mid string values and I'd rather not create if() with all possible combinations.

Is there a way of reading what's after lets say 3rd delimiter?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
HI @elseb ,

I am not sure why you would want that complication, but yes, Split would do it

Last( FirstN( Split( YourTextField, "," ), 3 ) ).Result

would get you the third item

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (2)

Report
@elseb

After you call Split, you can call the index function to retrieve the value by ordinal number.

Let's take the following input string:

Set(strInput, "y,n,n,y,n")

This will return the 3rd value (eg 'n')

Index(Split(strInput, ","), 3).Result

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (2)

Report

@timl ,Yep - forgot about the new Index function - @elseb both of these will work.

Was this reply helpful? Yes No
elseb 774 Moderator on at

Like (0)

Report

Thank you both, just what I needed! I think I will go Index as it looks neater to me.

Seb

Was this reply helpful? Yes No