Preventing a "When a row has been modified" flow from being triggered when a scheduled Dataflow is triggered??

[Robbo_Robson]

Hi there,

I have a dataflow when is scheduled for refresh every hour on the hour. However I have a a webflow, which has a Dataverse "When a row is modified" trigger. Now, when the Dataflow's scheduled refresh begins, so does the webflow. I've limited the concurrency to 10, as I'm being met with a message to say the flow is being used too much.

How can I limit the webflow to only being triggered, when a user modifies a row from a PowerApp, or table view, instead of the Dataflow? Is it a business rule situation?

Many thanks in advance

Robbo

[Koen5]

Dear Robbo,

There are several ways of doing this ... not sure which one is best suited to your needs:

1. Create a flag-file with a status. This file (could be an excel table) indicates if a flow is running or not. Any flow will set the flag to 'true' when it starts and to 'false' when it stops. If another flow wants to start, it first checks the flag-file and if the value is 'true', it will delay until the value changes.
2. Include in your flow which is triggered when something is modified a certain time-frame in which the flow cannot run (it will wait/hold). Obviously this timeframe is the time in which your scheduled flow runs.
3. Create a flow with a child-flow related to it. Basically you tie 2 flows together in which you can either trigger/check/hold related flows depending on the status of the other flow. For more information on this, suggest you refer to 'calling child flows' in the documentations/forums.

Hope the suggestions helps,

Happy flowing,

Koen

[Robbo_Robson]

Hi Koen,

Thanks for your reply I wasn't expecting such a quick turnaround on a forum!

Three great solutions there, and admittedly after I'd posted my question, I'd thought about the time limitations option. However, with the flag-file option, where does this file need to be stored?

Kind Regards

Robbo

[Koen5]

Dear Robbo,

Any OneDrive/Sharepoint location to which PowerAutomate has direct access would do.

Happy flowing,

Koen

[v-wenjuan-msft]

Hi @Robbo_Robson ,

Other than @Koen5 's great advice, I would like to introduce my proposition to you all.

You can build a new Choice type column in your Dataverse table to record the source of the modification. Limit "Filter rows" to Power Apps/table view, so that the flow will only be triggered when you modified items from these two methods.

Best regards,

Community Support Team _ Wenjuan Zou