Combo box to show item in ViewForm

Like (0) Share

Report

Posted on 9 Apr 2024 06:43:01 by Appleonwindows

123

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:

General Questions

All responses (3)

Answers (1)

Verified answer

v-bofeng-msft on 09 Apr 2024 at 07:00:56

Like (0)

Report
Re: Combo box to show item in ViewForm

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
Appleonwindows 123 on 09 Apr 2024 at 06:48:20

Like (0)

Report

Re: Combo box to show item in ViewForm

No, its empty inside.

I inputted Parent.Default, it told me it expected table value
v-bofeng-msft on 09 Apr 2024 at 06:46:32

Like (0)

Report

Re: Combo box to show item in ViewForm

Hi @Appleonwindows ,

Did you set the combo box's DefaultSelectedItems property?

Best Regards,

Bof