Answered

Parsing values from a text (label) field for use in the Items property of a dropdown control

(1) Share

Report

Posted on by TimV

I have a text field in a Power Apps form with values separated by commas (e.g., John Doe, Joe Smith, Jane Doe, etc.). I want to use each value in the Items property of a dropdown so, when the use clicks the dropdown, they see each value as a separate item in the dropdown list. I assume this can be done, but I don't know how to parse the values so they display as separate items in the dropdown. Thank you in advance for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,640 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @TimV ,

It would be

Split( SPListName.FieldName, "," ).Result

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

1) screen page drag and drop down box in screen page
2) dropdown ->item property ["John Doe", "Joe Smith", "Jane Doe"]
3) text label drag and drop in screen page
4) text label -> text property Dropdown1.SelectedText.Value

Was this reply helpful? Yes No
TimV 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response. Very helpful. Also, can you tell me how I can reference an individual value from the text field? For example, if the values are "John Doe, Jane Doe, John Smith," how can I reference only "Jane Doe" in a formula? Thanks.

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @TimV ,
One way is to wrap the Split() with an Index():
Index(Split(Label.Text,","),2).Result

Was this reply helpful? Yes No