Answered

Dropdown form field not using the correct sharepoint list choices

(1) Share

Report

Posted on by IT-AKF

Hello,

When I add a dropdown form field from a sharepoint list choices field, instead of showing the choices it showsa big list of numbered items, none of them present in the sharepoint list choices field.
This only happen with newly added form dropdowns, the ones that were added prior to this problem are working fine.

The first image is the form field, the second is the sharepoint list column config.

Thanks for any help!

Screenshot 2022-08-19 151430.png Screenshot 2022-08-19 151515.png

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@IT-AKF

I avoid choices fields in SharePoint. They offer little advantage in PowerApps and make things much more complicated when analyzing data. You can change the column type to a single line of text without losing data. In PowerApps, limit the choices by using a dropdown control in the card with the Items property ["Programada","Nao Programada"]. As long as you are not going to add more choices later, this is the simplest solution. After making the change in SharePoint remember to save them and refresh the browser. Then, in PowerApps, refresh the data source.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@IT-AKF

I avoid choices fields in SharePoint. They offer little advantage in PowerApps and make things much more complicated when analyzing data. You can change the column type to a single line of text without losing data. In PowerApps, limit the choices by using a dropdown control in the card with the Items property ["Programada","Nao Programada"]. As long as you are not going to add more choices later, this is the simplest solution. After making the change in SharePoint remember to save them and refresh the browser. Then, in PowerApps, refresh the data source.

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Can you please check the items property of this field in power apps

Was this reply helpful? Yes No
Verified answer

IT-AKF 45 on at

Like (0)

Report

Checked the DisplayFields property and they where all set to ["Value1"] instead of ["Value"] when the fields are automatically added to the form, after setting the data source!
Changing it to ["Value"] gets this running good again.

Never happened before, it's the second time this week that property fields are changed in apps that I am developing with no change at all in the app.

Thanks for the help @Drrickryp , @NandiniBhagya20

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@IT-AKF

Yet another reason to avoid choices type columns.

Was this reply helpful? Yes No