Jun 29 2021 11:11 AM
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
Jul 05 2021 10:35 AM
@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...
Jul 05 2021 10:41 AM
Jul 05 2021 05:14 PM
Jul 06 2021 01:57 AM
Jul 09 2021 01:00 PM
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
That should do it. Let me know if you have any problem or question.
Jul 10 2021 02:45 AM