Hello- I'm trying to keep a log/record of the changes made to a specific 'Choice' column type in a SharePoint list via the form and copy the change into a 'Multi-line text' column within the same list. For example:
Record1 is set to 'blank' as the choice by default (nothing is tracked right now in the multi-line col)
User1 goes to Record1 and changes the choice from 'blank' to 'status1' and saves the record (since the user selected/changed the choice, the multi-line col now shows something like: "User1 date/time: Choice changed to 'status1'"
Any thoughts or ideas on how to best do this, without too much coding in PowerApps?
I recommend enabling Versioning on the list, which will address the requirements with no effort. But, to check all the changes, you need to click item's Version History.
If you want to see all the changes in a column and if your SP list form is not customized, then you can write a simple Power Automate to update the multiline text field with everytime it changes.
If your SP list form is customized with Power App, then On Success property of form in the Power App, you can write Patch function to set mutiline text field value.
I hope the above steps will help you.
|If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.|
Thank you for the response. I do have versioning turned on and I do have a custom form built with PowerApps. I'm stuck on what code/formula needs to be used to capture the changes made to the status/choice box with Patch. The goal is to have a separate column that tracks the changes made to that field specifically. I'm a newby so any guidance/advice will go a long way. Thanks again.
The Super User program for 2022 - Season 2 has kicked off!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.