DefaultSelectedItems Using Variables for ComboBox

(0) Share

Report

Posted on by tlevine

230

Hi Community -

I am having some issues and hope that this may be a quick solve. I am looking to have the default selected item for my combox using a variable. I currently get the error "Expected Table value." I am setting the variable with on select & navigate from another screen and using this combox to filter the gallery on the current/new screen. This would be a huge user win if they are able to have the screen already filtered to the item they previously selected.

Any ideas how I can solve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

tlevine 230 on at

Like (0)

Report

This video has gotten me closer, but still unable to get it to work while using a contextual variable:

https://www.youtube.com/watch?v=zxlmIwAP0i0

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Without more details and based on the error message you are getting, I can tell that you are probably passing text as the defaultselected using a variable. You need to make sure it's a record of the items that populate the combo box.

Let me know the items property of the combo box, and how you are setting the variable which you want to use to set the defaultselected property.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (3)

Report
Hi @tlevine ,

Could you please share more details about the formula you used to initialize the ?

Do you want to set a default value within the ComboBox using a variable?

Based on the error message that you mentioned, it seems to tell that the DefautlSelectedItems property of the ComboBox is required to provide a Table value. Please check if you have set your variable as a Table value rather than a record value or single Text value.

I have made a test on my side, please consider take a try with the following workaround:

The data structure of RecordsCollection as below:

Set the OnSelect property of the "Initialize Var" button to following:

Set(DefaultOption, Table({ProductName: "Power BI"}))

On your side, you should initialize your variable as below:

Set(Var1, Table({DisplayColumn: "Specific Value"}))

Note: The DisplayColumn represents the column you used as display value within your ComboBox.

Please consider take a try with above sample solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
cmegow on at

Like (0)

Report

@v-xida-msft I have followed your instructions, but am unable to set my defaultselecteditem on my dropdown. The variable I've created from your instructions above does indeed create a table, but nothing appears in the dropdown box.

Here is the onSelect value:

Set(POProject, Table({'Project Lookup':'Project_Search_Budget_3'.Selected}))

The item field for Project_Search_Budget_3 is:
Filter(SortByColumns([@'FPC - Project Status List'],"Project_x0020_Lookup"), 'Small Project' = false)

Thanks for any help you can offer.

However, no value is being produced. Here are the values of my dropdown:
DefaultSelectedItems: POProject
Items: Choices([@'FPC-Purchase Orders'].'Project Name')

The 'Project Name' Column in sharepoint is a lookup column, which pulls information from the 'FPC-Project Status List' column 'Project LookUp'.

Was this reply helpful? Yes No
MASinc13 4 on at

Like (1)

Report

I hope this helps. If you are trying to get the defaultselecteditem to be the variable you captured in a DD or CB then use [Text(varNAME)].
In my scenario i want a location to be chosen before going into a order form.
Splash screen has a button that brings up the location DD. Button to capture variable. Close group screen.

On my form i have used the above formula as the defaultedselecteditem.

Hope this helps
I have a setup

Was this reply helpful? Yes No