SharePoint List linked dropdown only showing blank entries

(3) Share

Report

Posted on by Mattpst

160

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

I have the same question (0)

All responses (6)

Answers (0)

Kameshm05 302 Moderator on at

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

Was this reply helpful? Yes No
Mattpst 160 on at

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.

Was this reply helpful? Yes No
Marty_Dub 121 on at

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.

Was this reply helpful? Yes No
Mattpst 160 on at

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.

Was this reply helpful? Yes No
Mattpst 160 on at

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 :)

Was this reply helpful? Yes No
Suggested answer

CU02011756-0 2 on at

Like (1)

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.

Was this reply helpful? Yes No