Share
ReportDear all,
I have built an app using Google sheet as my data source.
To counter problems related to delegation I intend to update my Google sheet by deleting records that I don't need any more.
To do so I want to:
1/ copy the record that need to be deleted in another excel file (I manage to copy all records from my google sheet using Get Rows action and Insert Rows action).
PB: I am not able to filter only the rows I want to back up (I have one specific column with a "N" for the one I can copy and then delete
2/ delete the record from google sheet once it has been copied over to an excel "archive" datasheet
Step1 before triggering:
Google sheet
Step 2:
--> Copy data in excel for the record where "In_Building" = "N"
Step 3: Update google sheet by deleting these copied record
Thanks for your hint on how to build the Flow
All responses (
Answers (
425
