Design pattern for updating a list item in the future

%3CLINGO-SUB%20id%3D%22lingo-sub-2498474%22%20slang%3D%22en-US%22%3EDesign%20pattern%20for%20updating%20a%20list%20item%20in%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2498474%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20requirement%20to%20update%20items%20in%20a%20sharepoint%20list%2C%20but%20the%20item%20should%20only%20be%20updated%20and%20the%20new%20values%20for%20columns%20visible%20at%20some%20defined%20time%20in%20the%20future%20time.%20Something%20like%20the%20go-live%20date%20on%20a%20page.%20For%20example%2C%20a%20price%20list%20that%20has%20updates%20that%20will%20be%20live%20as%20of%20a%20certain%20date.%20Has%20anybody%20implemented%20such%20a%20design%20pattern%20that%20works%20and%20scales%20well%20%3F%20If%20necessary%20I%20can%20use%20power%20automate.%20I'm%20just%20looking%20for%20some%20best%20practices%20and%20a%20generic%20pattern%20that%20can%20be%20used%20for%20multiple%20scenarios.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20pointers%2C%3C%2FP%3E%3CP%3EStephane%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2498474%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPIs%20Developer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2516922%22%20slang%3D%22en-US%22%3ERe%3A%20Design%20pattern%20for%20updating%20a%20list%20item%20in%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2516922%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572423%22%20target%3D%22_blank%22%3E%40StephaneBouillon%3C%2FA%3E%26nbsp%3BFor%20modern%20list%2C%20you%20can%20use%20the%20%3CSTRONG%3EField%20Customizer%3C%2FSTRONG%3E%20extension%20to%20play%20with%20the%20data%20as%20per%20the%20need.%20Using%20this%20extension%2C%20you%20can%20hide%2Fshow%20the%20column%20data%20based%20off%20the%20certain%20date%20in%20the%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20the%20reference%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fspfx%2Fextensions%2Fget-started%2Fbuilding-simple-field-customizer%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fspfx%2Fextensions%2Fget-started%2Fbuilding-simple-field-customizer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2516928%22%20slang%3D%22en-US%22%3ERe%3A%20Design%20pattern%20for%20updating%20a%20list%20item%20in%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2516928%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20reference.%20This%20allows%20to%20change%20the%20UI%20when%20viewing%20the%20list%20using%20a%20browser.%20My%20need%20is%20for%20the%20data%20itself%20to%20be%20updated%20in%20a%20delayed%20fashion.%3CBR%20%2F%3E%3CBR%20%2F%3EStephane%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I have a requirement to update items in a sharepoint list, but the item should only be updated and the new values for columns visible at some defined time in the future time. Something like the go-live date on a page. For example, a price list that has updates that will be live as of a certain date. Has anybody implemented such a design pattern that works and scales well ? If necessary I can use power automate. I'm just looking for some best practices and a generic pattern that can be used for multiple scenarios.

 

Thanks in advance for any pointers,

Stephane

6 Replies

@StephaneBouillon For modern list, you can use the Field Customizer extension to play with the data as per the need. Using this extension, you can hide/show the column data based off the certain date in the column.

 

Please see the reference - https://docs.microsoft.com/en-us/sharepoint/dev/spfx/extensions/get-started/building-simple-field-cu... 

Thanks for the reference. This allows to change the UI when viewing the list using a browser. My need is for the data itself to be updated in a delayed fashion.

Stephane
do your data entry into ListA - do your data presentation from ListB i.e. get user to enter data into ListA - have a power automate flow that then delays until your predefined time, then creates the item in ListB
Thanks for your time and effort, is this something you have implemented ? The tricky part for me is determining the schedule for the power automate to not make it too narrow or too wide.

Hi @StephaneBouillon,

 

So, I've worked with a requirement similar to yours, and this was my solution. It is basically a demonstration of what Gristy said:

 

First, you create a list "Target", with all the columns you need. Then, you create a second list, let's call it "ToMigrate" and insert all the columns that you want to update in the "Target" list, plus an additional column, "DateOfMigration", of DateTime type, and a "TargetItem" column, which should be a lookup column to the "Target" list referencing the target item.

Then, you create a Power Automate flow, attached to the "ToMigrate" list.

The flow steps are

  1. When an item is created, then select the "ToMigrate" list.
  2. Delay until, then select the "DateOfMigration" column of the created item.
  3. Update item, select the "TargetItem/Id" column of the created item in the ID parameter, and then fill the other columns that you want to update as well.

That should do it. Let me know if you have any problem or question.

Thanks Carlos for your time and effort sharing your approach, this really helps.
Stephane