How to have a SharePoint list column show which records have been looked up to another list?

Copper Contributor

I have two lists:

1) Employees

2) Responsibilities

 

Employees list has a lookup column that shows multiple responsibilities of employees selected from the Responsiblities list. 

 

In the Responsibilities list, is there a way to have a column show which employee(s) have been assigned/looked up for that individual responsibility?

 

Many thanks!

Chris

1 Reply

@tortugacreative I suspect the only way to do this is with a flow in Power Automate.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)