cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TMMK64571
Helper I
Helper I

Choices of Lookup field displayed as numbers

I have created what I thought was a simple request form for another group, mimicing an existing process.  It is housed in SharePoint, and Choices are supplied by Lists.  After consultation, one of fields changed from Single line of text to Lookup.  I dropped the field and re-added it to the form, but the Choices are numbers rather than the items from the SharePoint list.

 

Where should I look for the error?

 

BQIT.PNG

Description.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

@TMMK64571 

Yes, that is a limitation of SharePoint.  12 lookup columns max.

 

Please close the thread by clicking accept solution on the appropriate post. 

View solution in original post

3 REPLIES 3
mdevaney
Super User
Super User

@TMMK64571 

What code are you using in the Items property?  It should be...

Choices(your_datasource_name.your_column_name)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." 

Unfortunately, this error had to do with the number of Lookup columns in the list.  I had 13, and the limit is 12.  I deleted one, but now I am getting the "No item to display error."  Seems like it is time to rebuild the form.

@TMMK64571 

Yes, that is a limitation of SharePoint.  12 lookup columns max.

 

Please close the thread by clicking accept solution on the appropriate post. 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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