Skip to main content
Nintex Community Menu Bar

Join two query list

  • October 1, 2018
  • 1 reply
  • 9 views

Forum|alt.badge.img+4

Hi Everyone

This the results from my querries

Lists 1:

Name          Role  

Tom             PM

Maxime        Head of IT

Alan             Business Owner

List 2:

Name     Status

Tom        Approved

Max         Rejected

Alan         Not required

So now, I'd like to do a join Where my role is equal to Head of IT or PM, I tried some things but nothing works

Any idea of what I could do?

Thanks in advance for your help happy.png

1 reply

Forum|alt.badge.img+5
  • October 12, 2018

you can use calculated value with lookup function in your formula.

hope this can help you,

regards

reva eka patria