Drop Down for Database field

[jup]

Hi all!

I have a nvarchar(50) field in my mssql table.

until now I created a edit form and placed this field on it. now I just have a text box:

Now I want to achieve this:

I want to set some predefined values in a dop down box as suggestion for the user. for example a drop down box that has the predefined values:

- Gate 1

- Gate 2

- No Gate

This values dont has to come from a database table. They are not dynamically so I just want to do it by "hard coding".

But I also want that the user can insert a custom text!!!

please help

thanks

jup

[Anonymous]

Hi @jup,

I made some tests for your problem
Soooo...
In a SharePoint List I created a String Column called "TextTest"

I created then a PowerApp with gallery, details and edit forms.
Il replaced the TextBox dedicated to my column "TextTest" with a ComboBox 1.

Here are the statements of my ComboBox :

SelectMultiple : false

IsSearchable : true

Items : ["Gate 1";"Gate 2";"No Gate"]

Here is the statement of my TextTest column Card :

Update : If(CountRows(ComboBox1.SelectedItems) = 0;
ComboBox1.SearchText;
First(ComboBox1.SelectedItems).Value)

Here is the statement of my Edit View :

OnVisible : Reset(ComboBox1)

Like that, the user can choose a field in the list but if he wants an other value, he writes it in the SearchItem section.

Best regards,

Louis

[v-monli-msft]

Hi @jup ,

Would you please explain more about how you want to achieve this? For example, did you mean that only when user pick the "No Gate" inside the dropdown control that they want to fill the value inside the textinput control? 

If so, then please try to follow below steps to achieve this:

1. Unlock the data card of this field inside the edit form. With the data card selected, insert the Dropdown control and set its Items property to:

["Gate 1","Gate 2","No Gate"]

2. Insert a textinput control.

3. Set below formula in the Update property of the data card:

If(Dropdown1.Selected.Value="No Gate",TextInput1.Text,Dropdown1.Selected.Value)

Regards,

Mona

[Anonymous]

Yes,

We have closely the same answer @v-monli-msft.

You have 2 different ways now @jup 

Regards,

Louis

[jup]

Hi !

I want to use louis' solution.

If I do so as explained, I'll get an error- see images attached.

Thanks

jup

[Anonymous]

Can you share to me your full formula screen to locate the error ? 
I confess I don't find your problem...

Regards, 

Louis

[jup]

please find attached 🙂

[Anonymous]

I mean that type of screen to locate the error in the function 🙂

[jup]

see attached 🙂

[jup]

and here