cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Recording an audit trail for changes to fields

Hi all,

 

I've seen a couple of similar posts but nothing conclusive.

 

I have a Power App form, where people enter information including a status. The status can be changed repeatedly.

I want to show all previous statuses, and the date it was entered. 

 

Is this possible? If so, how???

 

Jemma (PowerApps noob)

2 REPLIES 2
Highlighted
Dual Super User II
Dual Super User II

Re: Recording an audit trail for changes to fields

Assuming that the changes are made through Power Apps only you could easily store the status changes as a list entry in another list.  But I suspect what you want is to just query the versions that are saved each time the record changes.  The problem is versions are designed primarily to be restored, not as a data repository. So I don't think you will be able to use versioning to accomplish what you want.  You'll have to actually build an audit log in a separate list.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Super User
Super User

Re: Recording an audit trail for changes to fields

Hi @heytherejem ,

Firstly, if you are using SharePoint as a data source, just enable Versioning in List Settings.

Otherwise set up a separate List/Table containing Status, ChangeDate and ChangedBy fields (I will call it ChangeLog  and then on the OnChange of the Status field put something like (use your field names for the blue)

Patch(
   ChangeLog,   
   ThisItem,
   {    
      Status: YourStatusControl.Selected.xxxx
      ChangeDate: Now()
      ChangedBy: User().FullName
   }
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,202)