Dropdown box default value

(1) Share

Report

Posted on by Marty_Dub

121

I have a dropdown within an edit form that's linked to records in a SharePoint list.

All text and date fields in this form display the current Parent.Default values correctly of the selected item.

The dropdown however throws an error "Expected Table Value", and does not show the current selected items value as the default selected item.

What's the best way to go about correcting this?

Thanks as always!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Marty_Dub ,

What's the column type of 'Invoice Type'?

What's the formula of the data card's Default property?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Marty_Dub 121 on at

Like (1)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft - the column type for this field is 'Single line of text', and the data card's default property is ThisItem.'Invoice Type'

Cheers.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Marty_Dub ,

This is the root of the problem. If you want to use a dropdown control, you need to provide a table instead of a string.

I'm a bit confused, the value of that column ('Invoice Type') is just a text. Which options do you expect to be selected from the drop down?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Marty_Dub 121 on at

Like (1)

Report
Copy link

Link copied!

Thank you @v-xiaochen-msft - there are three items to choose from in the drop down ["NOI","RCTI","GEV"].

Essentially, I'd like the drop down to default to the value which has been recorded on that item when it was created (i.e. it will be one of the three options above).

Do I need to modify the SharePoint column type etc or is the solution within PowerApps?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @Marty_Dub ,

You don't have to change the column type.

Let's say you are using combo box control rather than dropdown control. Please try these types:

1\ Set items property of combo box to:

["NOI","RCTI","GEV"]

2\ Set DefaultSelectedItems property of combo box to:

If(IsBlank(LookUp(["NOI","RCTI","GEV"],Value=ThisItem.'Invoice Type').Value),["NOI"], Table({Value:LookUp(["NOI","RCTI","GEV"],Value=ThisItem.'Invoice Type').Value}) )

3\ Set Update property of the data card to:

<combo box>.Selected.Value

Best Regards,

Wearsky

Was this reply helpful? Yes No
Marty_Dub 121 on at

Like (1)

Report
Copy link

Link copied!

Amazing @v-xiaochen-msft - thank you, that worked a treat!

Was this reply helpful? Yes No