I have two lists MemberList and MemberCertsandQualsList. Both lists share several common columns:
Location Name and No.
Location County, etc...
I have a Patch in Power Apps that updates these fields in the MemberList. The update only has to change a single line of data in the MemberList, as each UnqID only appears once on that list.
I also need these same exact fields updated in the MemberCertsandQualsList every time they are changed/updated the MemberList. The process for updating the MemberCertsandQualsList may have to update multiple line items of the same information base on the UnqID depending on the number of certs or quals the member has in the system. The UnqID may appear several times in the MemberCertsandQualsList; consequently, the entire list (more than 5,000 items) would need to be check every time a members data is updated in the MemberList.
It is more prudent or of greater efficiency to use a Lookup (if such a thing is even possible) to pull the common fields into the
MemberCertsandQualsList, or to use a Flow to update the MemberCertsandQualsList every time there is an update of change to the MemberList?