You’re offline. This is a read only version of the page.
Hi,
I have two fields "Action" and the "Date" this action was done (then it is submitted).
Now this can be done multiple times, is there anyway to store a history of the "submits" these two fields have experienced?
Ie Today I marked "Sent to Business" for Sept 3rd 2023.
Next week I want to change it to Closed for Sept 7th 2023.
Is there a way or a field I can create to show the previous submission?
Thanks.
@Devvj ah ok my datasource is sharepoint, so the audit feature may not be the greatest.
Im liking the 2nd table.. write a new record to that each time.... i may have to do this! im gonna try it out and come back if i need any tips.
Hi @wonka1234
You would first need to save the data as individual records in one way or another, if you use Dataverse as datasource you could however turn on Audit and use that table in you Canvas app directly to get access to the change history on items. Not sure if there is a similar way in SharePoint.
That solution aside you could always set up a "history"-table in you data source and add a field thats a lookup to the item you want to save history for, in addition to set up a "old action value"-field and a "new action value"-field to hold the change made.
Then basicly write a new record to that table every time you make an update to the action.
Then you have a history/reference table with all the changes that are made for each action-record.
Hope the concept was clear 🙂
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
#1
WarrenBelz
146,601
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
