web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / tracking what fields h...
Power Apps
Answered

tracking what fields have been edited

(0) ShareShare
ReportReport
Posted on by

I have a requirement to track when an item has been changed (tracking this in a separate sharepoint list called Actions).  I currently do this by using the patch function after the on success of the form submission to the main list, I patch through for example that person X  updated field [abc] from [acme] to [not acme] etc...  works well when I'm only tracking what the change was.

 

However I now have the requirement to track not what was updated (ie. acme to not acme) BUT just which field was updated? so show that field [abc] and [def] and [ghi] were updated.. don't need what they were updated to. just that they were the ones edited... and trying to figure out the best way to do this?

 

I had thought that I could add a text box where I added all the fields as they were updated (concatenating them) and then used that box in my patch.. which would be fine if I could figure out how to do that !  or if there is a better way to do it?  The fields that are updated can just be listed in one field with a comma or other  separator..

 

Hopefully you can understand what I mean !    Any suggestions on best approach?

Categories:
I have the same question (0)
  • jbrit2020 Profile Picture
    632 on at

    I created an update tracking table in SQL and whenever a change is submitted, I patch the fields that suffered a change onto the table with the exact same button the users use to submit the change

     

  • Community Power Platform Member Profile Picture
    on at

    thanks @jbrit2020 unfortunately I was trying to keep it all within powerapps and maybe a little less complex solution?  

  • Community Power Platform Member Profile Picture
    on at

    Any other suggestions?

  • Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    If the item is a SharePoint list form then there might be simple solution. You can go into the List setting and under Versioning turn on version control. This will allow you to store and track items whenever they are changed.

  • Community Power Platform Member Profile Picture
    on at

    Thanks @Jeff_Thorpe  unfortunately I don't think that will work for me because as far as I know versioning just tells me which record has been updated not which field within that record?

  • Verified answer
    Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

     

     

     

    @Anonymous , the version history on a list shows which fields were changed and what they were changed to along with who changed it and when.


    2021-01-16_15h23_44.png

  • Community Power Platform Member Profile Picture
    on at

    Thanks @Jeff_Thorpe  not sure how I take that info and patch it over to my actions list?  but it's actually ok because I've found a work around using checkboxes !  in the on change property I tick a check box then I use the text of that checkbox to update the actions list 🙂  thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard