web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Back up Google sheet data into Excel + Delete Backed up records from Google sheet

(0) ShareShare
ReportReport
Posted on by

Dear 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

 

PierreMichelMat_0-1593158065000.png

Step 2: 

--> Copy data in excel for the record where "In_Building" = "N"

PierreMichelMat_2-1593158257340.png

 

Step 3: Update google sheet by deleting these copied record

PierreMichelMat_3-1593158310576.png

 

Thanks for your hint on how to build the Flow

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

Last 30 days Overall leaderboard