Share
Report
754Hi All - I've seen a few posts that are just about what I'm looking for but not 100%
I have 2 existing SharePoint lists. I want to do a 'bulk load' and update AccountName and AcctID from PE_List1 to those same fields in TIN_List2, We just added those fields in TIN_List2 so they are all empty. Both columns in PE_List1 are already populated with values. The common column for both lists is OTHER_ID (lets say) not all OTHER_IDs in TIN_List2 will be in PE_List1
So I want to update TIN_List2.AccountName and TIN_List2.AcctID with PE_List1.AccountName and PE_List1.AcctID values where TIN_List2.OTHER_ID = PE_List1.OTHERID.
After I do the initial bulk update I want it to be a scheduled flow to run every day only looking for items in TIN_List2 where AccountName and AcctID values. are null. Thoracically I could use that condition in the bulk update - since they are not null.
Both lists are already created though so I can't use a Created on or Modified trigger. Thanks in advance!
All responses (
Answers (
