Forum Discussion
Email notification without Alerts
Hi,
I have projects that go from stage 1 to stage 2 to stage 3. I have a report where users can attach comments to the project IDs to add context to any difficulties during each stage. The comments are submitted using a Power Apps integration and the comments are then inserted to the project ID tabel, so that comments from stage 1 can be shown on a card visual for stage 2.
Sometimes the users forget to submit these comments and I would like to set up notifications to remind them when a project ID moves from one stage to the next without a comment.
Is it possible to create a notification service in Power BI or Power Automate that notifies a user if a project ID goes from one stage to the next with a blank comment value?
Any help is much appreciated!
HI Anonymous
What you could do is to create a measure which counts the number of comments for the Project ID in each stage. Then if the count is zero fire off an alert that there are no comments?
1 Reply
- GilbertQSuper User
HI Anonymous
What you could do is to create a measure which counts the number of comments for the Project ID in each stage. Then if the count is zero fire off an alert that there are no comments?