I have a SharePoint list with a status column that I want to track all changes for. I figured I'd capture when list items are modified, then append the rows to a table in SQL, but since there are so many rows and potentially lots of status changes in a short period of time, I thought it'd be best to use a filter query within the 'get items' step (instead of a condition that would run through all the items). I'm forever learning Power Automate, so there may be a much better method to do this, but I'm trying to use the 'Has Column Changed: Status' field to filter, and it's not working - I'm assuming maybe because of the "/" needed in the internal name for the 'Has Column Changed: Status' field. Is it possible to use those fields in the filter query, or is there a better way to structure this?
Thank you all in advance!!
