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

[tisaigon]

Hi
i have issue with delete row in Google sheet flow
If value in column d = "Posted", delete row
But only one row deleted
Related guide: https://forum.pabbly.com/threads/qu...et-integration-through-pabbly.1387/#post-6540
Please see image and help
My Google sheet; https://docs.google.com/spreadsheets/d/1cbPDPQC7XqGcj5FRqd_epTKdNQS3JX0RuqwrB3nn_f0/edit#gid=0
Thank you

 

[Pabblymember11]

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.

 

[tisaigon]

@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"
}

 

[Pabblymember11]

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]

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.

 

[Pabblymember11]

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]

Super. thank you

 

[tisaigon]

@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:

Facebook post; facebook fanpage, facebook group, facebook content

New No,Posted Status,Post ID,Content,Media Link,Channel ID,Posted Time,Thời điểm tạo từ Podio Qua Google Sheet,Approved Status,Scheduled time,Page or Group,Channel Name,Media Type,FROM Podio Link,Podio Item ID Posted,111260241415031_254532903777039,ab de test test 4555 y666 666 test 333 trai tim...

docs.google.com

My flow:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[tisaigon]

Or only delete last row

 

[tisaigon]

@Supreme please help, thanks

 

[Pabblymember11]

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.