SharePoint online list choice fields not displaying options I populated

Question

Hello, I have a SharePoint list field called "Approved" which is a choice menu. I populated a choice of "Yes" but on the PowerApps form, the field has values like "Item 1", Item 2" etc. Please assist with fixing this. thanks,

Answer 1

Hi @Sherazad Ahmed,

Thanks for reaching out to us. We are very pleased to assist you.

Based on the information you have provided and the research I have done, it is likely that you are having problems with the Approved field and list data source binding in your power apps.

It is suggested that you please try the following possible solution:

Step 1: Check the Data Source in PowerApps

1. Open PowerApps and navigate to your form.
2. Select the form control that contains the "Approved" field.
3. In the Properties pane, check that the DataSource is correctly set to your SharePoint list.
4. Click on the "Fields" section of the form and verify that the "Approved" field is correctly connected to the right column.

Step 2: Fix the Items Property of the Dropdown

1. Select the dropdown control for the "Approved" field.
2. Go to the Items property (in the formula bar) and ensure it is set to:

      Choices([@YourListName].'Approved') 
      or
      Choices(YourListName.Approved)
   

   

Step 3: Ensure SharePoint Column is Properly Configured

1. In SharePoint, go to List Settings.
2. Find the Approved column and make sure:
   • It is a Choice column.
   • The available choices include "Yes" (and any other valid options).
   • The Allow multiple selections setting is disabled if not needed.

Step 4: Refresh Data in PowerApps

1. In PowerApps, go to the Data tab.
2. Click on your SharePoint data source and select Refresh.

Step 5: Remove and Re-add the Field (If Needed)

If the issue persists:

1. Remove the "Approved" field from the form.
2. Re-add it from the Fields pane.

Finally, in my test environment, it works fine.

If you have any questions, please do not hesitate to contact me.

Moreover, if the issue can be fixed successfully, please click "Accept Answer" so that we can better archive the case and the other community members who are suffering the same issue can benefit from it.

Your kind contribution is much appreciated.

Answer 2

Thank you Ling. The issue self resolved a few hours later. But I will keep your answer in mind for future.

thanks,