cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
btontheway
Level: Powered On

Automatically change a value in a datacard after a specified time

Hi there,

looking for some help to be able to automatically change a value in a datacard after a specified time.

I have a table coming from a Sharepoint list which I show in a DataTable plus I have an attached editform on the side, where I show the selected record from the Datatable.

I would set up a function, which automatically changes the value ("Offer Sent") to an other value ("Archive offer") in a column ("Status") in 14 days after the record was created. I have a column ("Opening date") with the creation date which serves as a basis date and I think the DateAdd with Today could help me in the formula, but I have no idea, if I should use a timer, a hidden button or something else...

Any help is highly appreciated.

Thanks, Tamas

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Automatically change a value in a datacard after a specified time

You could use Microsoft Flow to create a scheduled Flow that runs against your SharePoint list on a daily basis and changes the status to "Archive Offer" if the the open date is greater than 14 days and the current status is equal to "Offer Sent".

1 REPLY 1
Super User
Super User

Re: Automatically change a value in a datacard after a specified time

You could use Microsoft Flow to create a scheduled Flow that runs against your SharePoint list on a daily basis and changes the status to "Archive Offer" if the the open date is greater than 14 days and the current status is equal to "Offer Sent".