cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kavzz
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

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
v-yuxima-msft
Community Support
Community Support

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

       

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.

 

 

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

Thank You!

It worked 🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,154)