SOLVED

How to show the difference of modification points in Sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-2281972%22%20slang%3D%22en-US%22%3EHow%20to%20show%20the%20difference%20of%20modification%20points%20in%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281972%22%20slang%3D%22en-US%22%3E%3CP%3ENow%20we%20use%20Sharepoint%20list%20with%20%22Contents%20approval%22%20function.%3C%2FP%3E%3CP%3EBy%20this%20function%2C%20the%20approver%20can%20choose%20pending%20lists%2C%20but%20can't%20realize%20which%20columns%20are%20modified.%3C%2FP%3E%3CP%3EThe%20best%20is%20to%20let%20the%20approver%20see%20%22Before%22%20and%20%22After%22%20contents%20in%20the%20modified%20column.%20Is%20there%20some%20way%20to%20materialize%20this%20in%20Sharepoint%20function%3F%20Otherwise%2C%20need%20to%20develop%20the%20extended%20app%20by%20Powerapps%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2281972%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-2283178%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20show%20the%20difference%20of%20modification%20points%20in%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2283178%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F19689%22%20target%3D%22_blank%22%3E%40Kelly%20E%3C%2FA%3E%26nbsp%3BHi%20Kelly%2C%20Thank%20you%20for%20your%20thought.%20I%20understood%20what%20you%20said%2C%20thank%20you!%20Still%2C%20I%20am%20wondering%20how%20to%20show%20to%20the%20user%20in%20the%20case%20of%20bulk%20data%20changes%20on%20many%20rows%20simultaneously%2C%20but%20I%20think%20I%20can%20do%20that%20somehow.%20Thank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282530%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20show%20the%20difference%20of%20modification%20points%20in%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282530%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690668%22%20target%3D%22_blank%22%3E%40kenjoy84%3C%2FA%3E%26nbsp%3B-%20there's%20likely%20several%20ways%20to%20handle%20this.%20One%20could%20be%20to%20add%20another%20field%20to%20the%20list%20so%20you%20have%20a%20column%20with%20'old'%20and%20one%20with%20'new'.%20Use%20a%20flow%20to%20write%20the%20value%20to%20the%20old%20field.%20You'd%20have%20to%20write%20over%20the%20'old'%20with%20each%20change%20so%20you'd%20only%20see%20the%20most%20recent%20comparison.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20need%20the%20entire%20history%2C%20you%20could%20set%20up%20a%20separate%20list%20(direct%20copy%20of%20current)%20to%20use%20as%20a%20historical%20log.%20Each%20time%20a%20change%20is%20made%2C%20all%20new%20values%20get%20written%20to%20the%20historical%20log.%20Users%20could%20then%20filter%2Fsort%20that%20list%20to%20see%20all%20the%20changes%20to%20a%20line%20item%20over%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps.%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Now we use Sharepoint list with "Contents approval" function.

By this function, the approver can choose pending lists, but can't realize which columns are modified.

The best is to let the approver see "Before" and "After" contents in the modified column. Is there some way to materialize this in Sharepoint function? Otherwise, need to develop the extended app by Powerapps?

2 Replies
best response confirmed by kenjoy84 (Occasional Contributor)
Solution

Hi @kenjoy84 - there's likely several ways to handle this. One could be to add another field to the list so you have a column with 'old' and one with 'new'. Use a flow to write the value to the old field. You'd have to write over the 'old' with each change so you'd only see the most recent comparison. 

 

If you need the entire history, you could set up a separate list (direct copy of current) to use as a historical log. Each time a change is made, all new values get written to the historical log. Users could then filter/sort that list to see all the changes to a line item over time.

 

Hope that helps.,

@Kelly_Edinger Hi Kelly, Thank you for your thought. I understood what you said, thank you! Still, I am wondering how to show to the user in the case of bulk data changes on many rows simultaneously, but I think I can do that somehow. Thank you very much.