Hello everyone
- I need remove rows blank of a combobox from a field lookup of my list in sharepoint
- I attached a image
thank you
Solved! Go to Solution.
HI @cvazquc3 ,
Could you please share a bit more about the formula typed within the Items property of the Computers ComboBox?
Do you want to remove the blank rows from the available options within the Computers ComboBox?
Further, which column does your Computers ComboBox relates to? Is it the TypeEquipment column?
I assume that your Computers ComboBox connects to the TypeEquipment column in your SP list. Based on the needs that you mentioned, I think the Filter function could achieve your needs.
If the TypeEquipment column is a Choice type column in your SP list:
Set the Items property of the ComboBox to following:
Filter(
Distinct('20190211_case5',TypeEquipment.Value),
Result <> Blank()
)
On your side, you should type:
Filter( Distinct(Products, TypeEquipment.Value), Result <> Blank() )
If the TypeEquipment column is a Single line text type column in your SP list:
Set the Items property of the ComboBox to following:
Filter(
Distinct('20190211_case5', TypeEquipment),
Result <> Blank()
)
On your side, you should type:
Filter( Distinct(Products, TypeEquipment), Result <> Blank() )
More details about Filter function in PowerApps, please check the following article:
Best regards,
Hello
Thank you for your time
I solved formula in this option
Filter(Products.TypeEquipment, Not(IsBlank(TypeEquipment)))
Regards
HI @cvazquc3 ,
Could you please share a bit more about the formula typed within the Items property of the Computers ComboBox?
Do you want to remove the blank rows from the available options within the Computers ComboBox?
Further, which column does your Computers ComboBox relates to? Is it the TypeEquipment column?
I assume that your Computers ComboBox connects to the TypeEquipment column in your SP list. Based on the needs that you mentioned, I think the Filter function could achieve your needs.
If the TypeEquipment column is a Choice type column in your SP list:
Set the Items property of the ComboBox to following:
Filter(
Distinct('20190211_case5',TypeEquipment.Value),
Result <> Blank()
)
On your side, you should type:
Filter( Distinct(Products, TypeEquipment.Value), Result <> Blank() )
If the TypeEquipment column is a Single line text type column in your SP list:
Set the Items property of the ComboBox to following:
Filter(
Distinct('20190211_case5', TypeEquipment),
Result <> Blank()
)
On your side, you should type:
Filter( Distinct(Products, TypeEquipment), Result <> Blank() )
More details about Filter function in PowerApps, please check the following article:
Best regards,
Hello
Thank you for your time
I solved formula in this option
Filter(Products.TypeEquipment, Not(IsBlank(TypeEquipment)))
Regards
I'm creating a collection of the values from my column in my sharepoint list, would I use the filter function on the dropdown or when I create my collection?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
191 | |
95 | |
65 | |
63 | |
58 |
User | Count |
---|---|
243 | |
164 | |
91 | |
79 | |
78 |