question

MustaphaAitBencheikh-9124 avatar image
0 Votes"
MustaphaAitBencheikh-9124 asked ·

Sharepoint Online Lookup Column doesn't work when taping value

I have a list with Lookup column: when I select value in drop down it works normaly but when I tape value fields shows me No Data Value.... How can I solve this issue

78699-5.png78598-6.png


office-sharepoint-online
5.png (19.4 KiB)
6.png (21.6 KiB)
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @MustaphaAitBencheikh-9124 ,

Have you tried the solution? Does it solve your problem?

0 Votes 0 ·
MustaphaAitBencheikh-9124 avatar image
0 Votes"
MustaphaAitBencheikh-9124 answered ·

@Jerryzy-MSFT Please If you can help me solve this Issue !

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JerryXu-MSFT avatar image
0 Votes"
JerryXu-MSFT answered ·

Hi, @MustaphaAitBencheikh-9124 ,

For the part when I tape value fields shows me No Data Value...., do you mean "type"? So it works when you select from the options, and fail to return value when you type in? If so, please try to add the space between 1 and the left number. The look up column will recognize "1 059" but will not know what "1059" is. You can check the gif below:

78926-lookup.gif

Please have a test in your end. If it works the same in your list, I will say everything is working fine. It is a by-design behavior for lookup column.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


lookup.gif (77.3 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.