Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Join two query list

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

0 Kudos
1 Reply
Workflow Hero

Re: Join two query list

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

hope this can help you,


reva eka patria

0 Kudos
Accept as Solution Reply