Compare column values/match from two list and update and ID field

[mcinnisbr]

Hi,

I've tried many iterations and can't quite get this to work.  I'll keep the premise simple:

I have 2 lists.  List-A is a staff list with roles (pulled from azure), but no unique ID field.  List-B is a district list with roles and unique ID.  I would like a scenario that does the following:  If the 'Job' column from List-A matches the 'Job' Column from List-B, populate the the unique 'ID' from List-B into List-A.  

Thanks you for any help.

[Caspar_Rubin · Accepted solution]

Hey,

the following should work:

1. Get items of list B

2. Get items of list A with Filter Query job eq 'items('Apply_to_each_-_list_B_item')?['job']'

3. Update item in list A with the id-list-b dynamic value

Result:

[mcinnisbr]

@Caspar_Rubin  BTW, thank you!