Hello,
I have a Combo Box dropdown in a Form that populates my data from a SharePoint LookupColumn:
Choices([@'L11 - PFAM List Duplicate'].Building_x0020_Blocks)
However, the code above also returns a lot of blank values because there are a lot of blank values in the SP List.
I have attempted to use the Filter function to remove the Blank Vales but I can't seem to get this to work:
Filter(Choices([@'L11 - PFAM List Duplicate'].Building_x0020_Blocks), [@'L11 - PFAM List Duplicate'].Building_x0020_Blocks <> Blank())
Any help would be appreciated.
Solved! Go to Solution.
Hi @caruso1058 ,
Can you try:
Filter(Choices([@'L11 - PFAM List Duplicate'].Building_x0020_Blocks),Len(Value)>0) ?
Hi @caruso1058 ,
Can you try:
Filter(Choices([@'L11 - PFAM List Duplicate'].Building_x0020_Blocks),Len(Value)>0) ?
That works great!!
Thank you for your help with this!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
182 | |
46 | |
46 | |
34 | |
33 |
User | Count |
---|---|
260 | |
87 | |
79 | |
68 | |
67 |