I am currently using a "tracker" in Power BI to monitor status changes for items in a SharePoint list. My goal is to create some type of event log or a way to monitor the sum of status changes for each column. At the end of each month, I need to be able to calculate the sum of items that had each status during a particular month. For example, if an item went from status 1, 2 and 3; I need a record of the item in each one of the status columns (to generate the monthly total).
My idea is to use "When an item is created or modified" in SharePoint, but make the trigger based on if the "Status" has changed. Does anyone know if it is possible to define the specific field on the SharePoint list you want to use. I can't figure out how to make the trigger only respond when the "Status" field has changed.
This is the logic I believe will help me accomplish my goal:
When the "Status" field is changed on the SharePoint list; create an item on a different SharePoint list with the item name, new status, and date the status was changed. Then I can use the new SharePoint list in Power BI to filter reports.
Any help is GREATLY appreciated. I am new to PowerAutomate and I am very desperate to get this figured out.
