Get Date Modified of individual columns

Hi ak264,

there is no way to get the date modified of individual columns in SharePoint out of the box.

However, there are a couple of workarounds you can use:

Calculated columns

You can use a calculated column to get the date modified of a specific column, but it requires you to compare the value in the column with the value in the previous version. If the column values don't match, then the modified date for the row is the modified date for that column.

To do this:

- Go to the list where you want to add the calculated column.
- Click Settings > List settings.
- Under Columns, click Create column.
- Select Calculated and click Next.
- In the Column name field, enter a name for the calculated column, such as Column A Modified.
- In the Column type field, select Date and time.
- In the Formula field, enter the following formula:

=IF([Column A]=[Column A_PreviousVersion],"",[Modified])

Click OK to save the calculated column.

Power Automate

You can also use Power Automate to create a flow that will update a new column with the date modified of a specific column. To do this:

- Go to Power Automate.
- Click Create > Flow.
- Select Automated from blank.
- In the When an item is modified trigger, select the list where you want to track the date modified of the Choice columns.
- Click Add new action.
- Search for and select the Get item action.
- In the Site Address field, enter the URL of your SharePoint site.
- In the List Name field, select the list where you want to track the date modified of the Choice columns.
- In the Item ID field, enter the dynamic content for the ID of the modified item.
- Click Add new action.
- Search for and select the Update item action.
- In the Site Address field, enter the URL of your SharePoint site.
- In the List Name field, select the list where you want to track the date modified of the Choice columns.
- In the Item ID field, enter the dynamic content for the ID of the modified item.
- In the Field field, select the new column that you want to update with the date modified of the Choice column.
- In the Value field, enter the following expression:

{{triggerBody()?['Modified']}}

- Click Save.

Once you have created the calculated columns or Power Automate flows, you should be able to see the date modified of each Choice column in your list.

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-retrieve-the-timestamp-of-a-specific-columns-last/td-p/2135250