Combo box default value inside forms

(0) Share

Report

Posted on by AshishJaiswal

776

Hello Experts,

I am using forms to make entry in a sharepoint list - Form is in Edit Mode

I need to set default value for a combo box inside a form. This combo box is showing items off a choice column in sharepoint

Button the user clicks to get to this form does this

ResetForm(RequestForm);NewForm(RequestForm);Navigate('Form Screen')

Now I am having trouble to setup default value in this combox box

currently i trying below formula

Combo box items property

Choices([@'DWP Exceptions Tracker'].Product_x0020__x002F__x0020_Serv)

& defaultselecteditems as

LookUp('DWP Exceptions Tracker','Existing Product / Service'.Value = "New Technology or Service")

But the combo box is not displaying 'New technology or service' as default value

Please advise

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

Try this:

{Value: LookUp('DWP Exceptions Tracker','Existing Product / Service'.Value = "New Technology or Service")}

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report
Copy link

Link copied!

@eka24

Does not work

Was this reply helpful? Yes No
eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

What the difference between 'Existing Product / Service' and Product_x0020__x002F__x0020_Serv

Are that both choice columns?

You also said the combobox was in a forms?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report
Copy link

Link copied!

@eka24

That is the internal name of the column

Was this reply helpful? Yes No
eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

I suggest you change the Lookup formula using the Internal name instead of the Change name.

I rather you DONT change the column name in your sharepoint list. In that case you can recreate the column.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report
Copy link

Link copied!

@eka24

Doesn't seems to work.

Was this reply helpful? Yes No