Forum Discussion
PowerBI Trigger - Power Automate
- 2 years ago
None of that is possible. You need to do your validation in the flow itself - check for the array size to be exactly 1 before proceeding.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
Hi,
Thank you for your response.
I have a Power BI report with a table visual, and I've added a button that triggers a Power Automate flow. The issue I'm facing is that if the button is accidentally pressed without selecting a row in the table, the flow triggers and processes all rows in the table, which is problematic.
What I want to achieve is:
- Ensure that the flow only triggers when a single row is selected in the Power BI table.
- Prevent the flow from triggering or performing any action if no row or multiple rows are selected.
The trigger and table have the table same columns in it, so if pressed a row in the table it would only send one row. The issue I'm facing is that if the button is pressed without selecting a row in the table, the flow triggers and processes all rows in the table.
I hope that is enough info
Thank you much appreciated
John
None of that is possible. You need to do your validation in the flow itself - check for the array size to be exactly 1 before proceeding.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41