cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kkrick
Level: Powered On

Sharepoint dropdown not showing sharepoint data

Hello,

 

I have two dropdowns from sharepoint that I want on a FormViewer and a FormEditor. For whatever reason, the values do not display and I am receiving the error #Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference. This happens when these dropdowns are viewed as text on a FormViewer and similarly in an actual drop down on a form editor. In the editor it shows the correct number of options, but all of the options are #Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference . . .

 

Has anyone run into this? Any solutions out there?

5 REPLIES 5
hpkeong
Level 10

Re: Sharepoint dropdown not showing sharepoint data

Hi

I am using Excel and my newly created Apps are having the same problem. They are either:

1. Dropdown showing values but off position, or

2. Dropdown showing the first value and when clicked, no data showed., and then resume the first data again.

 

My solution:

1. Duplicate the old Dropdown (copy and paste)..everything back to Normal (works!), or

2. Create a new Dropdown (works!)

 

Possibility:

- When they release new edition, some bugs inside and corrupt our existing dropdown.

Pretty frustrating!

hpkeong
jvdlinden
Level 8

Re: Sharepoint dropdown not showing sharepoint data

Yesterday I have created a brand new SharePoint list. The purpose of this list is to collect feedback.

The list contains multiple Choice (menu to choose from) columns with the values: 1, 2, 3, 4 and 5.

The column settings are configured as required, choices are displayed using a Drop-Down menu, Fill-in choices are not allowed and there is no default value.

 

I have configured this column multiple times, and for two columns I am also getting the #Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference value displayed.

Both on the iPad and in the simulate mode within the designer app.

 

I am not expecting this kind of behaviour.

Has anyone been able to resolve this, or a way to troubleshoot this?

 

Thanks a lot.

Highlighted
ifti
Level: Powered On

Re: Sharepoint dropdown not showing sharepoint data

Hi,

 

I got my one resolved by doing the below steps:

  1. Open up the app in PowerApps
  2. Select the field that's showing this data > From the advanced section/Form Customization section on your right (it gets activated once the data card is selected)  > click on the ... next to the field name and change the value to something different than @odata.type (For my case, I had to choose "Name" for a People picker)

 

That's it. This should fix this issue.

 

Hope it helps other users.

 

Cheers,

Ifti

Anonymous
Not applicable

Re: Sharepoint dropdown not showing sharepoint data

Yes, that worked for me. It's important to make the change both on the DetailsScreen and the EditScreen. Thanks for sharing!

starwispy
Level: Powered On

Re: Sharepoint dropdown not showing sharepoint data

I was having this issue as well.  I found that changing the value to something other than @odata.type did not work for me, until I made the changes via the Options pane.  Refer to murali's comment on this post which explains how to implement the workaround in more detail.

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,205)