Show only recent entry from appended multi text field

%3CLINGO-SUB%20id%3D%22lingo-sub-1214045%22%20slang%3D%22en-US%22%3EShow%20only%20recent%20entry%20from%20appended%20multi%20text%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1214045%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all-%3C%2FP%3E%3CP%3EI%20have%20spent%20a%20couple%20of%20hours%20looking%2C%20but%20haven't%20had%20luck%20yet.%3C%2FP%3E%3CP%3EI%20have%20a%20multi%20text%20field%20in%20a%20custom%20list%20and%20I'd%20like%20to%20show%20only%20the%20most%20recent%20entries%20on%20modern%20pages%20rather%20than%20the%20standard%20%22View%20Entries%22%20link.%3C%2FP%3E%3CP%3EI%20found%20a%20script%20or%20two%2C%20but%20can't%20find%20the%20script%20editor%20web%20part%20and%20I%20also%20don't%20see%20the%20CEWP.%20I've%20even%20looked%20in%20classic%20experience.%20No%20luck...%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20ideas...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1214045%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1216364%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20only%20recent%20entry%20from%20appended%20multi%20text%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1216364%22%20slang%3D%22en-US%22%3EHi%20Arnie%2C%3CBR%20%2F%3EYou%20can%20find%20the%20modern%20script%20editor%20in%20the%20below%20link.%20Also%2C%20the%20documentation%20of%20how%20to%20install%20the%20script%20editor%20to%20the%20modern%20sites%20and%20how%20to%20use%20it%20with%20screenshots.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-fx-webparts%2Ftree%2Fmaster%2Fsamples%2Freact-script-editor%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-fx-webparts%2Ftree%2Fmaster%2Fsamples%2Freact-script-editor%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1216420%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20only%20recent%20entry%20from%20appended%20multi%20text%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1216420%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313369%22%20target%3D%22_blank%22%3E%40Arnie_Howes%3C%2FA%3E%26nbsp%3Byou%20won't%20see%20the%20CEWP%20or%20Script%20Editor%20web%20parts%20as%20they%20have%20not%20been%20released%20on%20modern%20SharePoint.%20I%20suspect%20that%2C%20like%20my%20company%2C%20most%20won't%20allow%20the%20github%20method%20mentioned%20by%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F144422%22%20target%3D%22_blank%22%3E%40Sudharsan%20K%3C%2FA%3E.%20As%20far%20as%20I%20am%20aware%20there%20is%20currently%20no%20way%20to%20show%20the%20most%20recent%20appended%20item%20in%20replacement%20of%20the%20View%20Entries%20link.%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%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1217943%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20only%20recent%20entry%20from%20appended%20multi%20text%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1217943%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BYou%20could%20use%20flow%20to%20do%20it%20-%20we%20use%20workflow%20in%20SP2013%20so%20we%20can%20see%20the%20most%20current%20comment%20when%20we%20export%20a%20list%20to%20excel%20that%20has%20an%20append%20style%20field.%20I%20think%20this%20would%20work%20with%20SPO%20and%20flow%2C%20but%20haven't%20tested%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20another%20multi%20line%20field%20call%20it%20something%20like%20'last%20comment'.%20Hide%20it%20on%20your%20forms%2C%20make%20sure%20it%20isn't%20an%20append.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20a%20flow%20to%20check%20to%20see%20if%20the%20actual%20field%20is%20empty%20or%20not.%20In%20SP2013%20for%20a%20rich%20text%20field%20we%20tested%20to%20make%20sure%20the%20actual%20field%20wasn't%20%3C%2FP%3E%3CDIV%3E%3C%2FDIV%3E.%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it%20isn't%20empty%2C%20copy%20the%20field%20to%20your%20'last%20comment'%26nbsp%3B%20field%20and%20use%20that%20column%20in%20your%20views.%20Hide%20it%20on%20the%20forms.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1218101%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20only%20recent%20entry%20from%20appended%20multi%20text%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1218101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F189854%22%20target%3D%22_blank%22%3E%40Robin%20Nilsson%3C%2FA%3E%26nbsp%3Byes%20you%20could%20have%20multiple%20columns%20for%20the%20comments%20(we%20do%20it%20for%20multiple%20approval%20comments%20for%20example)%20but%20the%20issue%20would%20be%20you%20would%20have%20to%20know%20how%20many%20comments%20you%20were%20going%20to%20get%20and%20then%20save%20each%20one%20to%20the%20relevant%20column%20via%20an%20action%20in%20the%20flow.%20Or%20it%20can%20be%20done%20with%20a%20Power%20Apps%20customized%20form.%20But%20as%20the%20question%20was%20specifically%20about%20the%20append%20that's%20why%20I%20answered%20the%20way%20I%20did.%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%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1218433%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20only%20recent%20entry%20from%20appended%20multi%20text%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1218433%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20all!%20The%20client%20decided%20to%20go%20another%20direction%2C%20but%20I%20am%20still%20going%20to%20pursue%20this%20as%20time%20allows%20because%20it's%20a%20trick%20I%20always%20wanted%20to%20figure%20out.%20Have%20a%20great%20week!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all-

I have spent a couple of hours looking, but haven't had luck yet.

I have a multi text field in a custom list and I'd like to show only the most recent entries (append entries) on modern pages rather than the standard "View Entries" link.

I found a script or two, but can't find the script editor web part and I also don't see the CEWP. I've even looked in classic experience. No luck...

Thanks in advance for any ideas...

5 Replies
Highlighted
Hi Arnie,
You can find the modern script editor in the below link. Also, the documentation of how to install the script editor to the modern sites and how to use it with screenshots.
https://github.com/SharePoint/sp-dev-fx-webparts/tree/master/samples/react-script-editor
Highlighted

Hi @Arnie_Howes you won't see the CEWP or Script Editor web parts as they have not been released on modern SharePoint. I suspect that, like my company, most won't allow the github method mentioned by @Sudharsan K. As far as I am aware there is currently no way to show the most recent appended item in replacement of the View Entries link.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User  

Highlighted

@Rob Elliott You could use flow to do it - we use workflow in SP2013 so we can see the most current comment when we export a list to excel that has an append style field. I think this would work with SPO and flow, but haven't tested it.

 

Create another multi line field call it something like 'last comment'. Hide it on your forms, make sure it isn't an append.

 

Use a flow to check to see if the actual field is empty or not. In SP2013 for a rich text field we tested to make sure the actual field wasn't <div></div>.

 

If it isn't empty, copy the field to your 'last comment'  field and use that column in your views. Hide it on the forms.

Highlighted

@Robin Nilsson yes you could have multiple columns for the comments (we do it for multiple approval comments for example) but the issue would be you would have to know how many comments you were going to get and then save each one to the relevant column via an action in the flow. Or it can be done with a Power Apps customized form. But as the question was specifically about the append that's why I answered the way I did.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

Thanks, all! The client decided to go another direction, but I am still going to pursue this as time allows because it's a trick I always wanted to figure out. Have a great week!