Answered

Selecting default values in Combobox from String

(0) Share

Report

Posted on by haniel

I am trying to preselect items in a combo box based on a string. The string is stored in a variable called TeamMemberText and has the following value

Kamy Tahmasbi, Ali Nazarzadeh

When I try try to load the values as default, the text shows up, but the items are not selected.

RenameColumns(Split(TeamMembersText,", "),"Result","Value")

Any thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@haniel

First, I hope you are referring to the DefaultSelectedItems property (DSI) and not the Default property. Default does nothing in a combobox.

Next, the DSI property must provide records that match the schema of the Items property. Your current DSI is only going to provide a table of records with a Value column...is that what you have for the Items property?

Was this reply helpful? Yes No
haniel 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes ,

Thanks for your prompt reply. Yes, I'm using the DSI property. In terms of the schema, I'm only providing the Value. Where can I get the full schema?

-Haniel

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@haniel
What is your Items property formula?

Was this reply helpful? Yes No
haniel 95 on at

Like
a
(0)

Report
Copy link

Link copied!

'Team Members'

This is the name of a SharePoint list I'm using to populate the CB.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@haniel

Then you will want to narrow the table schema. Using the list as your datasource is going to give you a record schema that has all of your columns as well as all of the built-in SharePoint columns. So, to match the DSI, you would need to provide the entire record from the list. That is most likely not necessary if you just narrow the table.

So, for example 'Team Members' is a table with records with all columns. 'Team Members'.Title would be a table with records with only a Title column.

If the Title column is where you are getting the team member name from, then just go with that, otherwise, change the .Title to the column that contains the value you want.

THEN, in the DSI, your formula would change to:

RenameColumns( Split(TeamMembersText,", "), "Result", "Title" )

Again, replace "Title" above with the appropriate column name from your items property.

That should match selections!

Was this reply helpful? Yes No
haniel 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @RandyHayes . Changing the Value to Title did the trick.

Was this reply helpful? Yes No
DragonLord 200 on at

Like
a
(0)

Report
Copy link

Link copied!

Getting error "The specified column "Result" does not exist?

Was this reply helpful? Yes No