Replacing text with an image in a list column (SharePoint Online)

%3CLINGO-SUB%20id%3D%22lingo-sub-2711523%22%20slang%3D%22en-US%22%3EReplacing%20text%20with%20an%20image%20in%20a%20list%20column%20(SharePoint%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2711523%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20Online%20list%20and%20on%20one%20column%20I%20have%20codes%20that%20correspond%20to%20icons.%20What%20is%20a%20good%20way%20to%20replace%20the%20text%20with%20corresponding%20icons%3F%3C%2FP%3E%3CP%3Ethanks%2C%3C%2FP%3E%3CP%3ENader%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22column.GIF%22%20style%3D%22width%3A%20124px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307614iBB064417DFC6D1AE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22column.GIF%22%20alt%3D%22column.GIF%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2711523%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2711609%22%20slang%3D%22en-US%22%3ERe%3A%20Replacing%20text%20with%20an%20image%20in%20a%20list%20column%20(SharePoint%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2711609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1144520%22%20target%3D%22_blank%22%3E%40NaderHadjebi%3C%2FA%3E%26nbsp%3Bif%20those%20icons%20are%20stored%20on%20your%20site%20then%20you%20could%20create%20a%20hyperlink%20or%20picture%20column%20(from%20List%20Settings)%20and%20for%20the%20%3CEM%3EFormat%20URL%3C%2FEM%3E%20dropdown%20click%20Image.%20Then%20you%20add%20the%20link%20to%20the%20icon%20into%20the%20column%20and%20it%20will%20display%20the%20icon%2Fimage%20in%20the%20list%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22flags.png%22%20style%3D%22width%3A%20893px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307618iA04C6EFAE3703A87%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22flags.png%22%20alt%3D%22flags.png%22%20%2F%3E%3C%2FSPAN%3E%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-2711782%22%20slang%3D%22en-US%22%3ERe%3A%20Replacing%20text%20with%20an%20image%20in%20a%20list%20column%20(SharePoint%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2711782%22%20slang%3D%22en-US%22%3EThanks%20Rob.%20I%20have%20to%20create%20the%20icons%20for%20each%20item.%20I%20am%20looking%20for%20a%20way%20to%20automatically%20swap%20out%20the%20names%20with%20the%20corresponding%20icon%20without%20having%20to%20do%20it%20row%20by%20row%2C%20since%20there%20are%20hundreds%20of%20rows.%3C%2FLINGO-BODY%3E
New Contributor

Hello all,

I have a SharePoint Online list and on one column I have codes that correspond to icons. What is a good way to replace the text with corresponding icons?

thanks,

Nader

column.GIF

6 Replies

@NaderHadjebi if those icons are stored on your site then you could create a hyperlink or picture column (from List Settings) and for the Format URL dropdown click Image. Then you add the link to the icon into the column and it will display the icon/image in the list:

flags.png

 

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

Thanks Rob. I have to create the icons for each item. I am looking for a way to automatically swap out the names with the corresponding icon without having to do it row by row, since there are hundreds of rows.

@NaderHadjebi not possible I think. You can't mix & match column types and can't just change a text column to a Hyperlink or Pitcure ort an Image column without losing the data.

 

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

@NaderHadjebi - I am afraid there is no such option within SharePoint. You can create a new column of picture type and then use Power of Power Automate (Flow) to update this icon column automatically every time there is a new item created or updated in the list. This would automatically update the icons based on the title of icon stored in different column.

Please note you need to ensure the images are uploaded in same document library for your flow to be simple and fast.
Thanks for the reply. I will try the Power Automate option. I will also try editing the original data file in Excel (I think there is a way to replace text with an image in excel) and make it in to a list again. I will update this thread with the results.

@NaderHadjebi @tauseefsh This is an update to the progress on resolving this. I have had some progress by formatting the column with JSON (did not take Power Automate or Excel Option). It is not 100% the way I want it, but getting there. I will make another post with the final result.
column formatting with JSONcolumn formatting with JSON