cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Phineas
Post Prodigy
Post Prodigy

SP Choice Column Data Not Appearing in PA Gallery



I have Gallery1 with test data.

The 'Picked Up / Dropped Off' and 'Dropped Off By' are formatted exactly the same Power Apps and SharePoint.

Power Apps
Gallery1
Items: Filter(SchedulerDetailsListCollection, Title in ComboBox2.SelectedItems)
Label 1 Items: ThisItem.PickedUpOrDeliver.Value
Label 2 Items:  ThisItem.DeliverBy.Value

SharePoint
Both columns are 'Choice' columns formatted the same way.

Phineas_1-1656883371245.png

Phineas_2-1656883422221.png

 

However, I can only see data in the 'Dropped Off By' field.

I recently converted the columns to Choice from Single line of text.

The only one that doesn't want to work is 'PickedUp/Dropped Off'.

 

Phineas_4-1656884332825.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@Phineas 

Your SharePoint list settings look correct.  Here is how I would troubleshoot the issue:

 

1.  Go to your SharePoint list and confirm your record in Power Apps has a value for the missing field

2. Refresh the connector on the data tab in Power Apps.

3. Open and close the app.

4. If none of these things work share the Items code in your gallery in this chat so I can diagnose further.

View solution in original post

3 REPLIES 3
mdevaney
Super User
Super User

@Phineas 

Your SharePoint list settings look correct.  Here is how I would troubleshoot the issue:

 

1.  Go to your SharePoint list and confirm your record in Power Apps has a value for the missing field

2. Refresh the connector on the data tab in Power Apps.

3. Open and close the app.

4. If none of these things work share the Items code in your gallery in this chat so I can diagnose further.

Did one through three; One of them solved the problem.

Thank you.

mdevaney
Super User
Super User

@Phineas 
Most likely refreshing the connector. SharePoint list schema and data changes don’t take effect until your refresh.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,414)