Split table value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone!

I'd like to put the content of a text box into a combo box split by commas.

I am using the below code but there is no splitting of the text. I've tried using the split function but

Table({Value:Gallery1.Selected.WereAnimalsInvolved})

I've tried putting the text into a data table and splitting that to no avail.

Split(DataTable1.Selected.Value,",").Result

Any advice you can offer would be greatly appreciated 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
I guess you want to do like this,
I used the TextBox's OnChange property : UpdateContext({varTemp: Self.Text})
For Combobox items property: Split(varTemp, ",")

Hope this helps.

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

Like (0)

Report
Copy link

Link copied!

Hi Ethan, thanks for replying! That's roughly what I want it to do yes, the initial information in my combo box is coming from a pre-filled form selected via a gallery (Gallery1), however there are additional values I'd like the user to see if they need to edit it, e.g. if they select No initially but then change their mind, they need to be able to unselect No and instead Select Yes and another like Dog.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
I still haven't got your point but as much as i understand,
1. If User wants to edit the response, save Yes into a variable then display the combobox with DisplayMode.Edit and if No then make combobox as DisplayMode.view.
2. If you want to dynamically show the field onto form based on If(AnimalsWereInvolved = "Yes", true,false) then this condition will be suitable on Combobox visible property.

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

Like (0)

Report
Copy link

Link copied!

Hi Ethan, thanks for trying to help, I think maybe I'm trying to do the impossible. This field that I am trying to split out was originally put together by two different fields on form submission, a "YES/NO" option and an animal species option (which is only available if YES selected), so it could just be "No," or it could be "Yes, Dog, Cat,"

I wanted to split it out in a post-submission review in case the user had missed something 🙂

Was this reply helpful? Yes No