cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JonasNilsson
Level: Powered On

Dropdown bounded to SQL Service View

I have a dropdown bounded to a SQL Server View (throuh Data Gateway).

The data consits of Text, Val (Year - Mounth, First date of month).

 

Everything is working great when i look at the app in preview mode, but when I publish it, the dropdown is showing empty rows (all rows are there, but with no text).

 

/Jonas

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dropdown bounded to SQL Service View

Hi @JonasNilsson

This type of behaviour can happen when 'Explicit Column Selection' is enabled.

https://powerusers.microsoft.com/t5/General-Discussion/Explicit-column-selection-with-collections-pu...

Could you try turning it off from File > App Settings > Advanced Settings to see if it makes a difference?

View solution in original post

1 REPLY 1
Super User
Super User

Re: Dropdown bounded to SQL Service View

Hi @JonasNilsson

This type of behaviour can happen when 'Explicit Column Selection' is enabled.

https://powerusers.microsoft.com/t5/General-Discussion/Explicit-column-selection-with-collections-pu...

Could you try turning it off from File > App Settings > Advanced Settings to see if it makes a difference?

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

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 Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,563)