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.
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.
Super UserHi 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 !
May I ask you one last question in this thread, collinq ?
I am sitting for a few hours and can not find where to set alerts for the created date column. Could you tell me how to do it?
- collinq
HI Anonymous ,
You can do this a number of ways. One way might be to create a column that is just a "1" or "0" if the date criteria matches (the created date is greater than yesterday sort of thing). And, then, just make that a card and it can alert if you have a "1" or "0". Or, you could try to use a filter where date is greater than .... and then use that as the alert.
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!