web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps ComboBox DefaultSelect...

Power Apps

Answered

ComboBox DefaultSelectedItems from SharePoint Single Line of Text

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello

I have the below in the DefaultSelectedItems for a ComboBox:

Split(LookUp('Assignments-Cases',Reference=PAReference).Departments,"; ").Result

Which works well as the Departments field is a Single Line of Text within SharePoint where values are separated by a semi-colon ;

PowerApps is pulling the values back as Result - see below:

However, this is not populating the ComboBox and is still blank:

Whereas I would expect it to be returning as:

Please could someone assist - thanks in advance!

Thanks

Bradley

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

What is your Items property of the ComboBox?

For DefaultSelectedItems to function properly, the signatures of your items must match the signatures of the records in the Items property.

In your case, you are setting the DefaultSelectedItems to a table of single column records with the column name of Result. If that is not what your Items property looks like (single column table with column name of Result), then they will not match.

Also, if you have trailing semi-colon on your data, the Split function will end up with a blank record and your results will be there, but not actually be selected.

A quick workaround on that is to change your formula to this:

Filter(Split(LookUp('Assignments-Cases',Reference=PAReference).Departments,"; ").Result, !IsBlank(Result))

But again, the signature of the DefaultSelectedItems and the Items property must still match.

I hope this is helpful for you.

Was this reply helpful? Yes No

Join the conversation