Problem setting default on a combobox

[DCHammer]

This seems like it should be really simple but I cannot figure out the syntax.

I want to display/set the values in the combobox to what has been chosen prior. Sharepoint list for datasource. Column is a Person/Group column.

Items: Choices([@'BusMarket - IBC PreSurvey'].'Sales Team Information')

I tried setting the default both using IsBlank and IsEmpty. The intent is that if there has been a selection made in this column/field, that the values be prepopulated on the form when the form opens in Edit mode. And if there has NOT been a selection made, that the current user is populated in the combobox.

Here is the last attempt:

If(
    IsEmpty(ThisItem.'Sales Team Information'),
    User(),
    ThisItem.'Sales Team Information'
)

I'm pretty sure my problem is that IsBlank and IsEmpty both expect a single record and ThisItem.'Sales Team Information' returns a table of records. But I cannot figure out how to correct.

Also, should I be setting the 'Default' property or the 'DefaultSelectedItems' property.

[SpongYe]

Hi @DCHammer 

Looks like DefaultSelectedItems and Choice column are referring to different columns/data.

As per your example, Choice items property is 

Items: Choices([@'BusMarket - IBC PreSurvey'].'Sales Team Information')

Then DefaultSelectedItems could be

comboBox.Selected.'Sales Team Information'

Example

In my example, items property is Choices(IssueTracker.SingleEvent)

and DefaultSelectedItems is ComboBox5.Selected.SingleEvent

Source: https://powerusers.microsoft.com/t5/Building-Power-Apps/DefaultSelecteditems-for-combobox-lookup/td-...

If you have any questions or feedback, please let me know. Have a great day! 😊

----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

[DCHammer]

That doesn't seem to work.

DataCardValue10.Selected.'Sales Team Information'

does not resolve. Which is a direct translation from the reply with my own control and data field names.

[SpongYe]

You are right that IsBlank and IsEmpty expect a single record, not a table.

To check if a table is empty, you can use the CountRows function to compare the number of rows with zero.

For example:

If(
    CountRows(ThisItem.'Sales Team Information') = 0, 
    User(), 
    ThisItem.'Sales Team Information'
)

This will return the current user if the table is empty, or the previous selection if the table is not empty.

With your code , you can use the IsEmpty function with the First function to check the first record of the table. 

If(
    IsEmpty(First(ThisItem.'Sales Team Information')), 
    User(), 
    ThisItem.'Sales Team Information'
)

I hope this helps you solve your problem.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

[DCHammer]

I'm really close now, I have managed to make things work to display the current data if the form is in Edit mode and not display if in New.

EditForm1.Default = New

crdSalesTeamInformation.Default = 

If(
    EditForm1.Mode = FormMode.New,
    Table(
        {
            DisplayName: User().FullName,
            Claims: "i:0#.f|membership|" & User().Email
        }
    ),
    ThisItem.'Sales Team Information'
)

cmbSalesTeamInformation.DefaultSelectedItems = ThisItem.'Sales Team Information'

So this properly displays current users in the Sales Team Information column when the form is in Edit mode.

But, when the form goes into New mode, it's not putting the current user into the combobox as a choice.

[DCHammer · Accepted solution]

I made it work. Here are the Form, Card and Control properties used:

Form:

Datasource : [@'BusMarket - IBC PreSurvey']

DefaultMode: FormMode.New

Datacard:

Datafield: "SalesTeamInformation"

Default: If(EditForm1.Mode = FormMode.New,Table({DisplayName: User().FullName,Claims: "i:0#.f|membership|"  User().Email}),ThisItem.'Sales Team Information')

ComboBox:

Items: Choices([@'BusMarket - IBC PreSurvey'].'Sales Team Information')

Default: If(EditForm1.Mode = FormMode.New, User())

DefaultSelectedItems: If(EditForm1.Mode = FormMode.New, Table({DisplayName: User().FullName,Claims: i:0#.f|membership|" & User().Email}), ThisItem.'Sales Team Information')