Applies to Product - Power Automate
What’s happening?
The flow connecting form data to a spreadsheet is not functioning as expected. When only one product is selected from the form, the spreadsheet still generates multiple empty lines (up to 9) instead of just one line for the selected product.
What’s happening?
The flow connecting form data to a spreadsheet is not functioning as expected. When only one product is selected from the form, the spreadsheet still generates multiple empty lines (up to 9) instead of just one line for the selected product.
Reason:
The flow setup includes multiple instances of adding a row to the table, which results in the flow creating empty rows when fewer than the maximum number of products are selected.
Resolution:
To resolve this, add a 'condition' action after each 'add a row to a table' action. This condition should check if the input from the form is true; if so, a new row will be created. If the condition is false, the action will be terminated. After implementing this change, a test should be run to ensure the required result is achieved.