Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

SharePoint List linked dropdown only showing blank entries

Like (2) ShareShare
ReportReport
Posted on 5 Aug 2024 15:16:53 by 136
Apologies if this has already been answered here. I have a PowerApps canvas app that has a dropdown linked to a SharePoint list (it's my list so I have edit perms). The data source is correctly linked, I have selected the data source for the dd so that it points to the correct SharePoint List.

When I preview the app the correct number options are displayed in the dd, but they are all blank?




 
If I add/remove items to the SharePoint List the returned options in the dd change accordingly, so I am pretty happy I have a connection. I've got 4 dd's connected to different lists and they all do the same thing.
 
 
 
What have I missed - hopefully something simple!
 
 
 
Thanks in advance for any pointers.
 
Matt
Categories:
  • Suggested answer
    CU02011756-0 Profile Picture
    CU02011756-0 2 on 02 Jan 2025 at 18:01:09
    SharePoint List linked dropdown only showing blank entries
    I was experiencing this same issue and I fixed it as well with two of the below replies as hints. I didn't quite understand what they were getting at, but here's what I did: 
     
    To clarify, this was for an integrated Power App form that was linked to SharePoint. I had copied the SharePoint list over with all of the same fields and then copied and pasted the code from the existing power apps form. The dropdowns were showing no items or blank. But you had the ability to select items from the dropdown but they were all blank values. 
    1. Click the dropdown
    2. Click the Fields option on the right (My screen said Primary Text and SearchField both equal value.)
    3. Click the dropdown where it says Value and select value AGAIN. Just the same selection. Do it for both Primary Text and SearchField. 
    4. Items appear in dropdown. 
  • Mattpst Profile Picture
    Mattpst 136 on 08 Aug 2024 at 12:27:59
    SharePoint List linked dropdown only showing blank entries
    I managed to get this working. There was more than one field selected from the list selected against the drop down. I cleared all and added back the specific column identifier and it worked. Thanks for the hint Kameshm05 :)
  • Mattpst Profile Picture
    Mattpst 136 on 08 Aug 2024 at 12:10:10
    SharePoint List linked dropdown only showing blank entries
     
    The DD's all have corresponding fields selected. I have checked and if I add new rows in the corresponding Lists, the blank entries in the DD increase also.
  • Marty_Dub Profile Picture
    Marty_Dub 121 on 07 Aug 2024 at 22:59:57
    SharePoint List linked dropdown only showing blank entries
    I'm experiencing the same issue. I think it's something to do with the new preview drop down. I have exactly the same code in an older app which works, but a new one I am building just brings back blank fields.

  • Mattpst Profile Picture
    Mattpst 136 on 07 Aug 2024 at 10:23:33
    SharePoint List linked dropdown only showing blank entries
    Hi @kameshm05
     
    The appropriate fields are selected field properties. If I change the backend SharePoint list, the number of returned items in the dropdown list change to match, but remain invisible.
  • Kameshm05 Profile Picture
    Kameshm05 289 on 06 Aug 2024 at 10:34:43
    SharePoint List linked dropdown only showing blank entries
    Hi Mattpst,

    Can you check the fields property for the dropdown? You should select the any one of the field from the fields property if it is not showing anything.




    Please reply here if it is not solve your problem.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,696

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,456

Leaderboard
Loading started