Forum Discussion
Power automate button clicking
- 2 years ago
For anyone whos irritated by this, there is a solution. Rather than powerautomate, use powerapps. You can enforce the OnSelect behaviour. End result is maybe a little better as I can have a submit and Edit button rather than just submit. That doesnt mean that the Powerautomate button couldnt be be made a little better and its functionality improved but in my specific use case I believe powerapps was the better choice.
Cheers
Hi samdthompson ,
Currently, Power BI does not offer built-in functionality specifically to enforce single-click behavior on the Power Automate button or to disable it temporarily after the first click. The Power Automate visual is designed to trigger the flow with each click, which, as you've noticed, can lead to multiple triggers if users double-click.
However, I can suggest a workaround that might help manage this behavior:
1. Modify the Flow to Check for Recent Executions: You could add a condition at the beginning of your flow to check if it has been executed recently (e.g., in the last few seconds) for the same user or the same set of data. If it has, you can terminate the flow early. This approach requires maintaining a log of executions, possibly in a SharePoint list or a database, where each execution is timestamped.
2. Use a Confirmation Step: Introduce a confirmation step at the beginning of your flow. After the button is clicked, the flow can send a confirmation message (e.g., via email or Teams) asking the user to confirm the action. Only proceed with the rest of the flow if confirmation is received. This adds an extra step but can prevent duplicate executions.
Or you can remind users. While not a technical solution, informing users about the single-click requirement for the Power Automate button through training or a note within the report can help reduce unintentional double-clicks.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.