Sending emails with power apps for data updates

Hi nmeh00,

You can use Power Automate (formerly known as Microsoft Flow) to create a flow that sends an email notification when your Power BI dataset is updated. Here are the steps to achieve this:

1. Trigger: Power BI - When Data Changes: Set up a Power BI trigger that monitors changes in your dataset. You can use the "Power BI" connector and select the trigger "When data changes in a dataset."

2. Filter (that is optional) If you want to send an email only when specific conditions are met (e.g., changes in specific columns or when a certain value is reached), you can add a condition or filter step in your flow.

3. Action: Send an email (V3): Add an action to send an email. You can use the "Office 365 Outlook" connector or the email service you prefer. Fill in the email details, such as the recipient(s), subject, and email body.

4. Customize Email Content: In the email body, you can include dynamic content from your Power BI dataset. Use the dynamic content menu to select values from the trigger step that provide information about the dataset update.

5. Turn on the Flow: Save and activate the flow. It will now monitor your Power BI dataset for changes and send an email notification when changes occur.

6. Test the Flow: To ensure it's working as expected, you can make a small update to your dataset to trigger the flow and verify that the email is sent.

7. Scheduling: You mentioned that you need weekly updates. You can add a schedule to your flow to run it on a specific day and time each week. This way, you can control when the email notifications are sent.