Forum Discussion
Alert when data changes
Hi Anonymous ,
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
I have done that in Power BI before - when a new record is added to get an alert. To do that, just add the "created date" field to each row (not the file itself since that never changes) coming from the Excel file and then in the Power BI data you can use an alert based on a column for created date being within 1 day (or 3 if you have weekend delays). You can make that a macro or something in Excel to make sure that the Created Date is always added when a row is added.
Super UserHi Anonymous ,
You can do this - if you know the date/time of field changes. Most fields in SharePoint can have a "modified date" field. So, you would have to have that field in your dataset and then you could add a formula with something like "if modified in the last x hours, then flag it" and use that flag as your inidicator for an alert to send whenever it inidicates a positive. Or, you could use incremental refresh and anything that is refreshed gets flagged and that becomes your indicator. Both of these solutions would require some setup and could easily miss things if you are trying to find "every single possible change on every single possible field". The hardest part here is for deleted rows - if it is deleted, by definition, it is not in the report anymore - and therefore can't be used as an indicator. (unless you are using flags for deletion, etc)
That said, if you are actually looking for "something changed in a field somewhere in SharePoint and I want to be alerted" then Power BI is not really what you are looking for in my mind. You are probably looking for a Power APP or set up a Power Automate inside of SharePoint that alerts on changes when they happen. If you are trying to determine what is changed when in SharePoint then versioning is already built in and that might be more beneficial.
Now, if you ARE strictly using versioning and every single change requires a new document version in SharePoint then you can report on each file and use the datestamp of the file change to know when things have changed.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Thank you for your informative response, collinq .
One more question. Lets say my task gets simplier and I need to get an alert only when new record is written into the excel. Is it possible to do that? SharePoint alerts me when any kind of modification gets done but I only need to know when new record is added.
- collinq
Hi Anonymous ,
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
I have done that in Power BI before - when a new record is added to get an alert. To do that, just add the "created date" field to each row (not the file itself since that never changes) coming from the Excel file and then in the Power BI data you can use an alert based on a column for created date being within 1 day (or 3 if you have weekend delays). You can make that a macro or something in Excel to make sure that the Created Date is always added when a row is added.
Thanks a lot collinq !
I'd a similar problem, that i so much overengineered (but really needed it) so that I'd built and app that posts a summary of changes of Excel files to selected group/private Teams chats.
Let me know if that works for you: https://appsource.microsoft.com/en-us/product/web-apps/iteratoeood1723739417240.tracksheet?tab=Overview
PS: I Hope this is not threated as spam, but i feel your pain.
