ComboBox won't split single line of text column

(0) Share

Report

Posted on by dixonbridgeta

125

Hi all,

I have a power app that is storing data to a SP list called; "Application Onboarding". I also have another SP site called "CSMB_APPLICATION_SUPPORT_INFO". I have a form with a data card that is from application onboading and is called: "servers" and stores the data there. Inside that datacard is a combobox8 that is pulling from the CSMB_APPLICATION_SUPPORT_INFO list. The combobox8 is pulling the server list column which is a single line of text and has multiple servers on 1 record separated by commas. Every time I try to use the split function, it fails and I get this error: "Invalid argument type (table). Expecting a text value instead". This is the code I tried in the Items property:

Split('ServerList', ",")

Split(CSMB_APPLICATION_SUPPORT_INFO.ServerList, ",")

**I am not using a gallery for this.

This comboxbox8 is also filtered to match the choice that was selected from another field (combobox3) in the defaultselecteditems property: (THIS WORKS GREAT)

Filter(CSMB_APPLICATION_SUPPORT_INFO,ApplicationName = ComboBox3.Selected.ApplicationName)

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!
Where I have a splist called WorkOrders

A dropdown, Dropdown2 where I select an item from it

my combobox items are

Split(First(Filter(WorkOrders,ID=Dropdown2.SelectedText.ID)).RequestDate, "/")

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

Thank you!! My next question is how do I get rid of the second scroll box with all that empty space?

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

hahaha umm

mine had no empty space down there.

maybe check here and make sure both primary and search are set to Value

cause top portion should show what you selected, and bottom, the optiosn you have to select from.
if that doesnt fix it perhaps throw a filter on the items to remove blanks from results

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

haha I swear, I always get the weird stuff.
So I tried that, and now what's happening is it is still showing all the other records in that column in the second scroll box..
The first scroll box operates correctly with matching to the other combobox and separating the items. But theres this second scroll box that shows all the rest of the records in that column. The blank spaces were just blank records that I didn't complete yet...

Items property:
Filter(CSMB_APPLICATION_SUPPORT_INFO.ServerList, !IsBlank(ServerList))

DefaultSelectedItems property:
Split(First(Filter(CSMB_APPLICATION_SUPPORT_INFO,ApplicationName = ComboBox3.Selected.ApplicationName)).ServerList, ",")

Display & Search property:
["ServerList"]

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!

If I am reading what you wrote right that's the correct behavior

In this example, 30 is my default selected item and my ITEMS is the split. so the only items I can choose from in this combo box are items that were in my split. if you put the items as filter() non blanks from a list, that second portion under top portion will always show every possible result from your filter as it is the items property.

If you wanted only the items from the split on the combo box to be choices the items property would also need to be same formula from your default

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (1)

Report
Copy link

Link copied!

That is exactly what I am looking for ! Thank you so much for your help and the quick responses, I really appreciate it.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

Anytime!

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

Can I ask you another question? Do you know how to do this with a multiline of text? The SP column got changed to multiline and doesn't have a comma delimiter. It just goes to the next line.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
Should be

Char(10)

as the delimiter I believe

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (1)

Report
Copy link

Link copied!

yes! thanks! I was trying Char(13) which didn't work. Char(10) works. Thanks so much!

Was this reply helpful? Yes No