cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Remove null values in a SharePointForm Drop down in power Apps

Hi!

I have a look Up column in a current SharePoint list which has some null values in the orginal list.

I want a dropdown for this column in the sharepoint form.

How do I remove the null values from it?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Remove null values in a SharePointForm Drop down in power Apps

Hi @Kavzz,

 

From your formula expression, I think you less the Filter( ).

Filter(Choices('Your SP list '.'Column Name'), Not(IsBlank(Value)))

 

Hope this can be helpful.

Best Regards.

Yumia

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Remove null values in a SharePointForm Drop down in power Apps

Hi @Kavzz,

 

Do you want to remove the null values in one lookup Column in Sharepoint?

And Templates is the lookup column in the Sharepoint?

 

I think you can try the formula expression as this:

Dropdown.Items: Filter(Choices('20190129_Divisons'.Templates), Not(IsBlank(Value)))           /*’20190129_Division’ is my Sharepoint List Name*/

 

On your side,Dropdown.Items: Filter(Choices('Your SP List’.Templates), Not(IsBlank(Value)))          

I test as next:

20190201removenullvalue1.jpg

DataCardValue14.Items: Filter(Choices('20190129_Divisons'.Templates), Not(IsBlank(Value)))  

20190201removenullvalue2.jpg

 

 

Hope this can be helpful.

Best Regards.

Yumia

       

Highlighted
Frequent Visitor

Re: Remove null values in a SharePointForm Drop down in power Apps

Hello @v-yuxima-msft,

Thank you! For your reply

I have tried the method that you have suggested.

I am not sure why though, I am still getting an error. 

See attached file for the errors.

 

 

Highlighted
Community Support
Community Support

Re: Remove null values in a SharePointForm Drop down in power Apps

Hi @Kavzz,

 

From your formula expression, I think you less the Filter( ).

Filter(Choices('Your SP list '.'Column Name'), Not(IsBlank(Value)))

 

Hope this can be helpful.

Best Regards.

Yumia

View solution in original post

Highlighted
Frequent Visitor

Re: Remove null values in a SharePointForm Drop down in power Apps

Thank You!

It worked 🙂

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 (10,971)