delete only 1 row while there are many rows that meet the condition (google sheet)

tisaigon

Member

Attachments

  • shot_230309_044034.png
    shot_230309_044034.png
    20.5 KB · Views: 13
  • shot_230309_044024.png
    shot_230309_044024.png
    23.8 KB · Views: 15

Supreme

Well-known member
Staff member
1678357219254.png


It appears that you haven't subtracted a row from the desired row to delete the selected row from the Google Sheets.

Though we have corrected it for now and it should work now.

1678357193571.png
 

tisaigon

Member
@Supreme Please check, i've received email about task error detail . Thank you
Hello TRAN NINH,

This email is to notify you that for the workflow "delete row after posted" , a recent task was not executed due to following error -​

Task History ID: IjU3NjcwNTY0MDYzMjA0MzI1MjZkNTUzMjUxMzQ1MTYxNTQzOSI_3D_pc
Step Name: Google Sheets > Delete Row
Connection Name: Facebook content
Task Error Detail:

{
"error > code": 400,
"error > message": "Invalid JSON payload received. Unexpected token.\n0,\t\t\t\t\"endRowIndex\":,\t\t\t\t\"startRowIndex\"\n ^",
"error > status": "INVALID_ARGUMENT"
}
 

Attachments

  • shot_230309_195420.png
    shot_230309_195420.png
    26.7 KB · Views: 7

Supreme

Well-known member
Staff member
Can you please check your history log once that whether are you getting the desired data from your Google Sheets: Lookup Value action step or not?
 

tisaigon

Member
Now, can delete rows, but not all rows with value "Posted" . I tried it and it deleted 2rows but there is still 1 row left unremoved.
 

Supreme

Well-known member
Staff member
Hey @tisaigon

If you have more than 1 row to delete you can use the Iterator action step after the Lookup Value action step.

Though we have added that for you now. Kindly give it a try and let us know.
 

tisaigon

Member
@Supreme
I have 10 rows meet condition (cell B(i) = Posted) but error / not delete.
Please see screen and help
Thank you
My Google sheet:

My flow:
 

Attachments

  • shot_230501_215910.png
    shot_230501_215910.png
    23.6 KB · Views: 4

Supreme

Well-known member
Staff member
You have passed the start row number in the end row and the end row number in the start row.

So, kindly correctly map the row index.

1683013078829.png


 
Top