Skip to main content
Nintex Community Menu Bar

Drop down box returning duplicate entry - SAP BAPI

  • February 17, 2017
  • 3 replies
  • 57 views

Forum|alt.badge.img+8

Hi

We have a drop down box quering a SAP table via BAPI.  when running the Method in the Cockpit, it returns 9 entries

When running the form, and using the drop down box, it shows 10 entries, with 1 of the entries being duplicated.


Any ideas as to why

3 replies

Forum|alt.badge.img+5
  • August 1, 2017

Hi braddo.


I would like to help, is it possible that I can have your design view screenshot?


Forum|alt.badge.img+8

Braddo,

 Instead of creating a table you should think about creating a SQL view and in that view filter out duplicate values. Create a smartobject from that view and use it for your dropdown. This should solve your problem.

 

Thanks,

Bryan Peters


  • January 10, 2022

how can I create a SQL View out of my list? 

Could you kindly assist me on this?