Unanswered

DefaultSelectedItems Expected Table Value?

(0) Share

Report

Posted on by ariashirazi

Hi there all,

I have a gallery connected to a data source of pre-existing Forms data. I am attempting to create a "New Form" functionality built within Power Apps, which recreates all the questions.

Every unique item is stored in the variable "varItem". If the user were to click "New Form" and type in an email in the text input, the value of the text input is varItem.Email, which connects it to the "Email" column of the original data source.

Problems:

However, when I try to connect the user's input of a dropdown, which is connected to a different cascading data source, and type "varItem.Platform" in DefaultSelectedItems, it comes up with "Expected Table Value" error. Moreover, the dropdowns come up with the correct number of options, but show blank.

Attachments:

I attach screenshots of the cascading data source, in case there is an issue with it. To note, the platforms dropdown, which is connected with Distinct('Demand App Reference List', Platform) is the only one which shows correctly. The Lab dropdown correctly switches the options, but they are all blank, as below.

Categories:

Building Power Apps

datasource2.png

empty lab dropdow...

expectedtablevalu...

I have the same question (0)

All responses (8)

Answers (0)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
HI @ariashirazi ,

In the DefaultSelectedItems, you need to also refer to the DisplayField (you did not post the Items). I am assuming here that this is a single selection control.

{YourDisplayFieldName: varItem.Platform}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report

you can use [varItem.Platform] in DefaultSelectedItems this will not give you error

Was this reply helpful? Yes No
ariashirazi 8 on at

Like (0)

Report

Hi there Warren,
The Items for the Platform is Distinct('Demand App Reference List', Platform)

and the Items for the Lab is Filter('Demand App Reference List', Platform = DropdownCanvas1.Selected.Value)

Somehow the Platform options show perfectly, and the Lab ones are blank. I didn't quite understand the DisplayField thing, please could you explain? Thanks so much for your help!

Was this reply helpful? Yes No
ariashirazi 8 on at

Like (0)

Report

Hi there, thanks for your response. It resolves the error, but I should be able to view the data from the original forms, but I can't. (see attached)

I need to be able to see the prefilled data as with Team Type. What's the issue? Thank you!

blank.png

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@ariashirazi ,

Assuming it is the Platform Combo Box we are talking about here and also assuming that varItem.Platform is a Text value and the Combo Box is a single selection, your DefaultSelectedItems would be

{Value: varItem.Platform}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@ariashirazi ,

I now see you are using Modern Controls. Before we go any further, please see if all of that works with Classic Combo Boxes.

Was this reply helpful? Yes No
ariashirazi 8 on at

Like (0)

Report

Hi Warren,

This gives me the same result. It provides the correct number of Lab options dependent on Platform chosen, but they are all still blank for some reason.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@ariashirazi ,

OK - back to basics with Classic Combo Boxes - can you please list for each

Items

Primary Text (select box and then Edit in right panel to view this)

DefaultSelectedItems

Update of the Data Card

Was this reply helpful? Yes No