Drop Down for Database field

(0) Share

Report

Posted on by 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

Categories:

General Questions

I have the same question (0)

All responses (15)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Drop Down for Database field

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

Was this reply helpful? Yes No
v-monli-msft on at

Like (1)

Report
Re: Drop Down for Database field

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Drop Down for Database field

Yes,

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

You have 2 different ways now @jup

Regards,

Louis

Was this reply helpful? Yes No
jup 60 on at

Like (0)

Report

Re: Drop Down for Database field

Hi !
I want to use louis' solution.

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

Thanks
jup

4.PNG

5.PNG

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Drop Down for Database field

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

Regards,

Louis

Was this reply helpful? Yes No
jup 60 on at

Like (0)

Report

Re: Drop Down for Database field

please find attached 🙂

screen.PNG

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Drop Down for Database field

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

Was this reply helpful? Yes No
jup 60 on at

Like (0)

Report

Re: Drop Down for Database field

see attached 🙂

here.PNG

Was this reply helpful? Yes No
jup 60 on at

Like (0)

Report

Re: Drop Down for Database field

and here

error.PNG

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Drop Down for Database field

Ok I see, I think I had the same error...

Try to erase the ".Value" at the end of the function, you put a "." and you take the first given proposition

Keep me informed 🙂

Was this reply helpful? Yes No