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?
Solved! Go to Solution.
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:
DataCardValue14.Items: Filter(Choices('20190129_Divisons'.Templates), Not(IsBlank(Value)))
Hope this can be helpful.
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.