cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AraSaber12
Level 8

Drop down menu in Form new

Hi Guys,

 

I have a table in my SQL server named Employee. In this table i have a column called "Kostenplaats" which is included numbers. 

 

I tried to change the property of this text box to a drop down menu, but this was not avalible. So i delete this and i manualley added a drop down menu for this column. As you can see it works but when i add an employee then i select a number for example 1300 then i want to check this in my SQL server. Unfortunately i see in this column "kostenplaats" a Null value.

 

This the Item property formula: SortByColumns(Distinct('[ISL].[Employee]_1',Kostenplaats),"Result",Ascending)

 

Untitled.png

 

So i don`t know what i am doing wrong? Can somebody please help for this issue?

 

Best Regards!

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Drop down menu in Form new

Hi @AraSaber12 ,

Have you bind the Drop down box to the Kostenplaats field successfully within your Edit form?

Based on the issue that you mentioned, I think there is something issue with the binding between the Drop down box and the Kostenplaats field successfully within your Edit form.

I have made a test on my side, and don't have the issue that you mentioned. Please take a try with the following workaround:3.JPG

 

4.JPGSet the Items property of the Drop down box within the EmpDept Data card to following:

Sort(Distinct('[dbo].[Employees]',EmpDept),Result, Ascending)

On your side, you should type:

SortByColumns(Distinct('[ISL].[Employee]_1',Kostenplaats),"Result",Ascending)

Set the Update property of the EmpDept Data card to following:

Dropdown1.Selected.Value

On your side, please set the Update property of the Kostenplaats Data card in your Edit form to following:

YourDropdownBox.Selected.Value

Or

YourDropdownBox.Selected.Result

If the Kostenplaats field in your SQL table is a Int type column, please modify above formula as below:

Value(YourDropdownBox.Selected.Value)

Set the Default property of the Drop down box to following:

ThisItem.Kostenplaats

Please check the attached GIF screenshot for more details:

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Drop down menu in Form new

Hi @AraSaber12 ,

Have you bind the Drop down box to the Kostenplaats field successfully within your Edit form?

Based on the issue that you mentioned, I think there is something issue with the binding between the Drop down box and the Kostenplaats field successfully within your Edit form.

I have made a test on my side, and don't have the issue that you mentioned. Please take a try with the following workaround:3.JPG

 

4.JPGSet the Items property of the Drop down box within the EmpDept Data card to following:

Sort(Distinct('[dbo].[Employees]',EmpDept),Result, Ascending)

On your side, you should type:

SortByColumns(Distinct('[ISL].[Employee]_1',Kostenplaats),"Result",Ascending)

Set the Update property of the EmpDept Data card to following:

Dropdown1.Selected.Value

On your side, please set the Update property of the Kostenplaats Data card in your Edit form to following:

YourDropdownBox.Selected.Value

Or

YourDropdownBox.Selected.Result

If the Kostenplaats field in your SQL table is a Int type column, please modify above formula as below:

Value(YourDropdownBox.Selected.Value)

Set the Default property of the Drop down box to following:

ThisItem.Kostenplaats

Please check the attached GIF screenshot for more details:

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

AraSaber12
Level 8

Re: Drop down menu in Form new

Hi @v-xida-msft ,

 

Thank you so much! It works and this was the solution you gave me: 

YourDropdownBox.Selected.Result

 

Best regards,

 

Ara

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (3,627)