Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

  • 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?