SharePoint List linked dropdown only showing blank entries

Like (2) Share

Report

Posted on 5 Aug 2024 15:16:53 by Mattpst

144

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:

Connecting to Data

All responses (6)

Answers (0)

Suggested answer

CU02011756-0 2 on 02 Jan 2025 at 18:01:09

Like (0)

Report
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.

Click the dropdown

Click the Fields option on the right (My screen said Primary Text and SearchField both equal value.)

Click the dropdown where it says Value and select value AGAIN. Just the same selection. Do it for both Primary Text and SearchField.

Items appear in dropdown.
Mattpst 144 on 08 Aug 2024 at 12:27:59

Like (2)

Report

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 144 on 08 Aug 2024 at 12:10:10

Like (1)

Report

SharePoint List linked dropdown only showing blank entries

Hi Kameshm05

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 121 on 07 Aug 2024 at 22:59:57

Like (2)

Report

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 144 on 07 Aug 2024 at 10:23:33

Like (1)

Report

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 302 Super User 2025 Season 1 on 06 Aug 2024 at 10:34:43

Like (1)

Report

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