You’re offline. This is a read only version of the page.
7
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.
After your condition - no need to check the value of a column in a previous version if that column has not changed.
I usually reference Trigger Window Start Token and Trigger Window End Token for the Since and Until values.
You can check the values of previous versions of any column but you'll need too make a REST call.
That is exactly what I was looking for! Thank you so much! I have another question. Do you know if it is possible for me to reference what the previous status was before the status was changed? I attached photos so you can see how I have it set up.
You'll want to use the SharePoint Get changes for an item or file action. Here is a link to a blog post with more information.
Share
Report
All responses (
Answers (
