After many days of trying, I cannot proceed past “Missing value of required parameter ‘rowNumber’.”
I’m trying to build a simple scenario that pulls the next unused blog keyword from a Google Sheet, stamps the “Used” column with a timestamp, then continues to an HTTP call and an Outlook email.
The sheet has two columns: Column A is “Keyword” and Column B is “Used”.
The scenario flow is Google Sheets – Search Rows → Google Sheets – Update a Row → HTTP – Make a request → Microsoft 365 Email.
The goal is to find the first row where “Used” is blank and update that row.
The consistent failure is on the Update a Row step with “BundleValidationError – Missing value of required parameter ‘rowNumber’.”
In the Execution Inspector I can see that this happens because Search Rows returns “Total number of bundles: 0,” so nothing is passed forward.
For Search Rows, I’ve selected the file and tab using the pickers (My Drive → / AI Blog Keywords → Sheet1), set “Table contains headers” to Yes.
To fetch the next unused keyword I’m filtering on the “Used (B)” column with the operator “Is empty,” limiting to 1 result, ordering by __ROW_NUMBER__, and sorting ascending. I’ve also run an exact-match test by switching the filter to “Keyword (A) equals” and pasting the full keyword string from the sheet, which should be on row 6. In both cases the Search Rows module still reports zero bundles.
I’ve re-selected Drive, Spreadsheet, and Sheet on both modules to avoid a mismatch, confirmed Field Type as String, and left the value and date render options on “Formatted value” and “Formatted string.”
Thanks in advance for any guidance on why Search Rows won’t return a bundle in this setup.
