cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Dropdown error

Hi , 

 

I have a dropdown for Country's .But I can see only 3 fields in it , why because NULL Value is there in that table ,

note:- I should not drop the Null Value

 

Country

America,

Argentina,

Mexcio,

China, 

NuLL

4 REPLIES 4
Highlighted
Super User
Super User

Re: Dropdown error

@MamathaReddy694 
Please show a screenshot of the problem.  I don't know what you mean.

Highlighted
Helper II
Helper II

Re: Dropdown error

Hi,

 

I am not gating any error in the power apps , The table is having in Country Column one Row is having Null ,

That's the reason I am not able to get the fields in the dropdown.

If this is not Clear I will give an screenshort to you.

 

Thankyou.

Highlighted
Super User
Super User

Re: Dropdown error

@MamathaReddy694 
I would like 2 things: the code you used in the Items field of the dropdown and a screenshot.  Thanks!

Highlighted
Helper II
Helper II

Re: Dropdown error

Hi,

 

This is the formula I am using in the Items field of the dropdown

 Distinct(DataBase_Name,MARKET)

 I can see only 3 values in the dropdown.

The attachments are SQL Column and Dropdown.

 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,054)