Sharepoint dropdown not showing sharepoint data

[Kkrick]

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?

[hpkeong]

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!

[jvdlinden]

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.

[ifti]

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]

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

[starwispy]

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.