Lookup Column Content – SharePoint Stack Exchange


I have two list: Members / Members Training

A Member’s ‘Status’ can be Active or Inactive.

The Member’s Status column appears in both lists, but is only updated in the Member list, by Power Apps.

Is there a way to make the ‘Status’ column in the Members Training list a Lookup column that will automatically pull the ‘Status’ of each Member (based on the their UnqID – a column on both lists), and update that Status in the Member’s Training list every time it is changed in the Member list?