cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rwade
New Member

SharePoint Event Log Ideas

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.

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User III
Super User III

@rwade 

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.  

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

5 REPLIES 5
ScottShearer
Super User III
Super User III

@rwade 

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.  

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

rwade
New Member

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.Flow 2.jpgFlow 1.jpeg  

@rwade 

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.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Do I make the REST call before the condition, or do I make the REST call in the condition before I create the item? Sorry if this is a dumb question, I am new to Power Automate.

@rwade 

After your condition - no need to check the value of a column in a previous version if that column has not changed.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,453)