Hello,
So I am a complete dummy (worse than a newbie) to PowerApps
I am trying to remove blanks from a drop down box which is linked to a look up column in a Sharepoint list. The problem is that the list has 4 columns, each with a different number of entries (column 1 has 7, column 2 has 12, column 3 has 8 etc). So the look up combo box shows several blanks rows for the shorter columns.
My only workaround would be to make 4 different lists of a single column each. Not very efficient I think.
Is there a formula or property to filter or hide the blank rows in the combo box?
- Main Sharepoint List with the look up column is named: FP Q&As23
- lookup column name in that list is : CB section
- Sharepoint list which has the data being looked up is named: QAData
- Dropdown box in PowerApps Studio (customize form option) is labeled CBsection
- Card (i.e.with label and combo box) = CB section_DataCard1
- Combo box = DataCardValue11
- The ‘items’ in Fx when the drop down is selected in PowerApps customize form shows: Choices([@'FP Q&As23'].CBsection)
Thanks
