Canvas Apps - Split with delimiter and get individual string values

(0) Share

Report

Posted on by SanjayAdsure201

Dear All,

I'm new to Power Apps so the question may seem basic.

I'm fetching a dynamic string from DB which is having slashes in between for example "A/B/C/D/E" now I want to split this using delimiter (slash in this case) and get "individual" values like, "A", "B","C","D" & "E" and then set it to the individual textboxes on page. (I'm having 5 textboxes on the page)

I am using split function but it's giving me table values which I can set to dropdown but unable to take individual string values from this.

Can you please help?

Thanks & Regards,
Sanjay Adsure

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

shoog 2,164 on at

Like (1)

Report
Copy link

Link copied!
You can use the Index function to get a specific element from an array, so for example if you assign the split outcome to a variable varSplitString, you would use

Index(varSplitString, 2)

would get the second row from the split.

If you want to make it more dynamic, you could create a gallery with the checkbox inside it, use the variable as Items for the gallery and set the checkboxes according to the items in the gallery.

Was this reply helpful? Yes No
rb 835 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Assuming you know that there will always be 5 values for your 5 text boxes, you can collect your 'Split()' using 'ClearCollect()' and then reference using 'Index(x, x).Result'

Example:
Button:
ClearCollect(colSplits, Split("A/B/C/D/E", "/"))
Text Boxes:
Index(colSplits, 1).Result

Now, if the number of values is not known, I would recommend looking in to Galleries/Collections and exploring other tutorials and documentation online which covers the handling of dynamic data sets.

Was this reply helpful? Yes No
SanjayAdsure201 83 on at

Like (1)

Report
Copy link

Link copied!

Dear @shoog ,

Thank you very much! 🙂

Thanks,
Sanjay

Was this reply helpful? Yes No