Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago
Solved

Power Automate trigger - How do I start a flow when my data is updated?

Good morning, I'm trying to make a flow that starts when my semantic model (data source) is updated.

The data is in a workspace where it is updated daily.

When they are updated I want it to be exported to PDF and sent by mail (these last 2 parts I already have and they work, I just need help with the trigger).

Could someone give me a hand? I searched and it turns out that there used to be the trigger "When a dataset is updated", but it is no longer there. Do you know any other way to start the flow?
I attach screenshots of what I have, I reiterate, I just need to know how to make the start. (I used to have a manual triger)

Emphasize that the data source and the report are in the same workspace.

Thank you very much in advance and good day 😄

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Syndicate_Admin ,

     

    Thanks saud968  for the quick reply. I have some other ideas for you to consider:

    1. You mentioned that you refresh daily, so you can set up a scheduled refresh and then create a scheduled cloud flow, please note that the time to run the flow should be after the scheduled refresh time.

    2. Or you can create a data source change trigger (the screenshot uses sharepoint as an example) and add the action as shown below.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

2 Replies

  • saud968's avatar
    saud968
    Memorable Member

    To trigger a Power Automate flow when your data source is updated. Since the "When a dataset is updated" trigger is no longer available, you can use the "When a dataflow refresh completes" trigger instead. Here’s how you can set it up:

    Create a New Flow:

    Go to Power Automate and select Create > Automated cloud flow.
    Enter a name for your flow.
    Select the Trigger:

    Search for the "When a dataflow refresh completes" trigger and select it.
    Configure the Trigger:

    Choose the workspace and the specific dataflow that you want to monitor for updates.
    Add Actions:

    After the trigger, add the actions to export the data to PDF and send it via email (which you already have set up).
    This setup will ensure that your flow starts whenever the dataflow is refreshed, effectively replacing the old trigger.

    If you need more specific conditions, such as triggering only when certain fields are updated, you can use the "When a row is added, modified, or deleted" trigger and set up conditions to filter the updates

    Best Regards
    Saud Ansari
    If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!


  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Syndicate_Admin ,

     

    Thanks saud968  for the quick reply. I have some other ideas for you to consider:

    1. You mentioned that you refresh daily, so you can set up a scheduled refresh and then create a scheduled cloud flow, please note that the time to run the flow should be after the scheduled refresh time.

    2. Or you can create a data source change trigger (the screenshot uses sharepoint as an example) and add the action as shown below.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.