Solved

Nintex 365 Responsive list lookup displays ID instead of value

  • 2 October 2023
  • 4 replies
  • 86 views

Badge +1

I have a form with a list lookup element.

When connecting it to the correct list and sharpoint online column everything works as intended.

I can select streetnames from the form’s dropdown.

 

But after submitting its displaying the corresponding ID number of the streetname of the list, instead of the streetname itself.

 

When opening the sharepoint list item the streetname is visible.

When pulling the item from the list using PowerAutomate the streetname is also visible.

When intervening using PowerAutomate to create an item using the same list and bypassing the Nintex form the streetname is also visible.

 

What is happening in the form that it’s passing the ID value instead of the streetname.

 

I delete the control, published the form, readded the control and published again > no fix
I deleted the sharepoint list and column, recreated those > no fix
I created the sharepoint online views > no fix

I’m clueless.

icon

Best answer by SimonMuntz 3 October 2023, 23:38

View original

4 replies

Userlevel 6
Badge +22

Hi @LSNN,

Is the sharepoint column connected to the lookup control a text column or a lookup column?
If its a text column, this may be why it shows the ID.

Badge +1

The SharePoint column is a choice column with drop-down.

Userlevel 6
Badge +22

If you use a lookup column in SharePoint does that resolve the issue?

Badge +1

YES! After 2 weeks of endless troubleshooting and cursing, this seems to be the way to fix it. WOW…

At least for new items it works, for items already existing on the list it is not fixed but you can’t have it all.

 

Thanks!

Reply