External data in list column

%3CLINGO-SUB%20id%3D%22lingo-sub-3289962%22%20slang%3D%22en-US%22%3EExternal%20data%20in%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289962%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%20everyone%2C%20I'm%20trying%20to%20connect%20a%20column%20of%20a%20SharePoint%20list%20with%20a%20column%20of%20an%20Excel%20file%20in%20OneDrive%20to%20have%20the%20list%20of%20social%20names%20of%20customers%2C%20I%20arrived%20at%20the%20screen%20that%20I%20attach%20but%20I%20do%20not%20know%20if%20it%20can%20be%20done%20and%20in%20case%20how.%20Can%20anyone%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SharepointExternalColumn.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F364541i4A988FA7909F75ED%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22SharepointExternalColumn.jpg%22%20alt%3D%22SharepointExternalColumn.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3289962%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%20list%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3290132%22%20slang%3D%22en-US%22%3ERe%3A%20External%20data%20in%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3290132%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1195052%22%20target%3D%22_blank%22%3E%40ChrisCloud%3C%2FA%3E%26nbsp%3Binstead%20I%20would%20look%20at%20doing%20this%20with%20an%20app%20in%20Power%20Apps%20where%20you%20can%20have%20multiple%20data%20sources%20can%20filter%20a%20gallery%20of%20items%20and%20so%20on.%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%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3290064%22%20slang%3D%22en-US%22%3ERe%3A%20External%20data%20in%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3290064%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EThe%20external%20data%20column%20in%20SPO%20does%20not%20cover%20the%20scenario%20you%20have%20here%20unfortunately...indeed%2C%20I%20would%20advice%20to%20avoid%20the%20use%20of%20that%20column%20that%20is%20based%20on%20a%20service%20Microsoft%20has%20not%20updated%20for%20years.%3C%2FLINGO-BODY%3E
Occasional Contributor

hello everyone, I'm trying to connect a column of a SharePoint list with a column of an Excel file in OneDrive to have the list of social names of customers, I arrived at the screen that I attach but I do not know if it can be done and in case how. Can anyone help me?

 

SharepointExternalColumn.jpg

2 Replies
Hi,
The external data column in SPO does not cover the scenario you have here unfortunately...indeed, I would advice to avoid the use of that column that is based on a service Microsoft has not updated for years.

@ChrisCloud instead I would look at doing this with an app in Power Apps where you can have multiple data sources can filter a gallery of items and so on.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)