Combo box to show item in ViewForm

(0) Share

Report

Posted on by Appleonwindows

129

I'm having a bit of trouble with one part of my Power App. I'm using a ComboBox (dropdown list) to get information from a SharePoint list. It's supposed to look at one specific column and then give me a list of options based on that. Everything works great when I'm just looking at the dropdown list.
The formula in the combobox are attached as follows:

OnChange
Set(RecordVariable, LookUp(Sort('Table', 'Year', SortOrder.Descending), 'Name' = If(IsBlank(ComboBox1.Selected.Value), ComboBox1.SearchText, ComboBox1.Selected.Value)))

Items
Distinct('Table'.'Name','Name')

DisplayFields
["Value"]

SearchFields
["Value"]

But when I try to look at the same information in the view form, there's a problem - none of the information shows up. I'm not sure why this is happening or how to fix it.

Has anyone else had this problem? Does anyone know how to fix it? I'm stuck and would really appreciate any help you can give.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-bofeng-msft on at

Like (0)

Report

Hi @Appleonwindows ,

Did you set the combo box's DefaultSelectedItems property?

Best Regards,

Bof

Was this reply helpful? Yes No
Appleonwindows 129 on at

Like (0)

Report

No, its empty inside.

I inputted Parent.Default, it told me it expected table value

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @Appleonwindows ,

Could you please show me the value of the Parent.Default ?

If ‘Name’ is a text type column , you could set the combo box's DefaultSelectedItems property to:

[{Value:ThisItem.Name}]

Best Regards,

Bof

Was this reply helpful? Yes No