SOLVED

External field in List - Copy content of other list

%3CLINGO-SUB%20id%3D%22lingo-sub-1453874%22%20slang%3D%22en-US%22%3EExternal%20field%20in%20List%20-%20Copy%20content%20of%20other%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1453874%22%20slang%3D%22en-US%22%3E%3CP%3EAll%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20a%20PMO%20manager%20in%20my%20company.%26nbsp%3B%20Head%20of%20PMO%20recently%20created%20a%20new%20project%20list%20containing%20information%20about%20all%20the%20projects%20in%20our%20company.%26nbsp%3B%20I%20have%20a%20subset%20of%20fields%20I%20would%20like%20to%20maintain%20pertinent%20only%20to%20my%20projects.%26nbsp%3B%20Understandably%2C%26nbsp%3B%20they%20don't%20want%20to%20add%20these%20fields%20to%20the%20overall%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20create%20another%20list%20that%20captures%20the%20Project%20Name%20from%20the%20original%20list%20for%20all%20records.%26nbsp%3B%20Then%20I%20can%20add%20my%20few%20fields%20and%20manage%20off%20of%20the%20second%20list%20(as%20long%20as%20there%20is%20a%20record%20in%20the%20original)%3F%26nbsp%3B%20If%20I'm%20in%20the%20same%20site%20-%20can%20this%20be%20done%20without%20code%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1453874%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20List%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454320%22%20slang%3D%22en-US%22%3ERe%3A%20External%20field%20in%20List%20-%20Copy%20content%20of%20other%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454320%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695280%22%20target%3D%22_blank%22%3E%40projectguy455%3C%2FA%3E%3A%20Yes%2C%20you%20can%20do%20this%20without%20coding.%3C%2FP%3E%3CP%3E1)%20Create%20a%20new%20list.%3C%2FP%3E%3CP%3E2)%20Add%20you%20own%20fields.%3C%2FP%3E%3CP%3E3)%20Also%2C%20add%20column%20with%20type%20as%20lookup%20and%20use%20Original%20list%20%22project%20name%22%20column.%3C%2FP%3E%3CP%3E4)%20This%20way%20all%20the%20project%20names%20in%20the%20original%20list%20will%20show%20up%20in%20the%20dropdown%20lookup%20column.%3C%2FP%3E%3CP%3E5)%20Any%20projects%20name%20gets%20updated%20will%20show%20up%20in%20the%20lookup%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20It%20helps%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EIf%20I%20have%20answered%20your%20question%2C%20please%20mark%20your%20post%20as%20Solved.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EIf%20you%20like%20my%20response%2C%20please%20give%20it%20a%20Thumbs%20Up.%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1458797%22%20slang%3D%22en-US%22%3ERe%3A%20External%20field%20in%20List%20-%20Copy%20content%20of%20other%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458797%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679665%22%20target%3D%22_blank%22%3E%40Ashish_Kohale%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20input%20-%20this%20ended%20up%20not%20working%20for%20a%20couple%20of%20reasons.%26nbsp%3B%20Ideally%2C%20I%20wanted%20to%20have%20the%20%22target%22%20list%20on%20a%20different%20site%20than%20the%20%22source%22.%26nbsp%3B%20Could%20have%20talked%20them%20into%20creating%20additional%20list%20on%20their%20site%20though.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20started%20looking%20at%20lookup%20columns.%26nbsp%3B%20It%20won't%20bring%20over%20special%20fields%2C%20like%20people.%26nbsp%3B%20These%20were%20exactly%20the%20fields%20that%20I%20wanted%20to%20bring%20over.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20ended%20up%20with%20a%20solution%20though.%26nbsp%3B%20Power%20Automate.%26nbsp%3B%20Changes%20to%20the%20source%20end%20up%20copying%20to%20the%20target.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20youtube%20video%20that%20taught%20it%20to%20me%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DKYsMNoc7aPY%26amp%3Blist%3DWL%26amp%3Bindex%3D29%26amp%3Bt%3D0s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DKYsMNoc7aPY%26amp%3Blist%3DWL%26amp%3Bindex%3D29%26amp%3Bt%3D0s%3C%2FA%3E%26nbsp%3B.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459042%22%20slang%3D%22en-US%22%3ERe%3A%20External%20field%20in%20List%20-%20Copy%20content%20of%20other%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695280%22%20target%3D%22_blank%22%3E%40projectguy455%3C%2FA%3E%26nbsp%3B%3A%20Yes%2C%20If%20source%20and%20Target%20are%20not%20from%20same%20site%20then%20PowerApps%20and%20PowerAutomate%20are%20the%20best%20approach%20nowadays%20which%20makes%20our%20life%20easier.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHappy%20Learning%20!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20%26amp%3B%20Regards%2C%3C%2FP%3E%3CP%3EAshish%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459113%22%20slang%3D%22en-US%22%3ERe%3A%20External%20field%20in%20List%20-%20Copy%20content%20of%20other%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695280%22%20target%3D%22_blank%22%3E%40projectguy455%3C%2FA%3E%26nbsp%3Bwith%20Power%20Apps%20and%20the%20SharePoint%20Power%20Apps%20web%20part%20you%20can%20have%20your%20list%20stored%20on%20one%201%20site%20and%20display%20it%20on%20the%20second%20site%20(or%20as%20many%20sites%20as%20you%20want).%20Any%20changes%20are%20saved%20back%20to%20the%20list%20on%20the%20first%20site%2C%20That%20method%20means%20you%20don't%20need%20to%20use%20Power%20Automate%20to%20keep%20the%20lists%20in%20sync.%20You'd%20need%20to%20build%20a%20simple%20app%20in%20Power%20Apps%20and%20use%20the%20list%20from%20the%20first%20site%20as%20the%20data%20source%20and%20include%20whichever%20columns%20you%20want.%20Once%20you%20save%20and%20publish%20it%2C%20copy%20the%20App%20ID%20and%20paste%20it%20into%20the%20Power%20Apps%20web%20part%20on%20the%20second%20site.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

All,

 

I'm a PMO manager in my company.  Head of PMO recently created a new project list containing information about all the projects in our company.  I have a subset of fields I would like to maintain pertinent only to my projects.  Understandably,  they don't want to add these fields to the overall list.

 

Is there a way to create another list that captures the Project Name from the original list for all records.  Then I can add my few fields and manage off of the second list (as long as there is a record in the original)?  If I'm in the same site - can this be done without code?

4 Replies
best response confirmed by projectguy455 (New Contributor)
Solution

@projectguy455: Yes, you can do this without coding.

1) Create a new list.

2) Add you own fields.

3) Also, add column with type as lookup and use Original list "project name" column.

4) This way all the project names in the original list will show up in the dropdown lookup column.

5) Any projects name gets updated will show up in the lookup column.

 

Hope It helps !

 

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

@Ashish_Kohale 

 

Thank you for the input - this ended up not working for a couple of reasons.  Ideally, I wanted to have the "target" list on a different site than the "source".  Could have talked them into creating additional list on their site though.

 

Then I started looking at lookup columns.  It won't bring over special fields, like people.  These were exactly the fields that I wanted to bring over.

 

I have ended up with a solution though.  Power Automate.  Changes to the source end up copying to the target.

 

Here's the youtube video that taught it to me - https://www.youtube.com/watch?v=KYsMNoc7aPY&list=WL&index=29&t=0s .

@projectguy455 : Yes, If source and Target are not from same site then PowerApps and PowerAutomate are the best approach nowadays which makes our life easier. 

 

Happy Learning ! 

 

Thanks & Regards,

Ashish

@projectguy455 with Power Apps and the SharePoint Power Apps web part you can have your list stored on one 1 site and display it on the second site (or as many sites as you want). Any changes are saved back to the list on the first site, That method means you don't need to use Power Automate to keep the lists in sync. You'd need to build a simple app in Power Apps and use the list from the first site as the data source and include whichever columns you want. Once you save and publish it, copy the App ID and paste it into the Power Apps web part on the second site.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User