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
Unanswered

Google Drive error

(0) ShareShare
ReportReport
Posted on by

I wonder about this error.

 

How do I do in order to add columns to the spreadsheet when I got this error?

 

Google Drive error.JPG

I dont understand where to specify the spreadsheet columns.

 

J

Categories:
I have the same question (0)
  • Stephen Siciliano - MSFT Profile Picture
    on at
    Re: Google Drive error

    Hello,

     

    In order to use Google Sheets you need to have the table column names in the first row of the worksheet. These will show up as text boxes in your flow for you to fill out.

     

    Thank you,

    -Stephen

  • Community Power Platform Member Profile Picture
    on at
    Re: Google Drive error

    It works when spreadsheet is located in OneDrive, but it is not working with google drive. In fact, the insert row option is not more available for drive.

     

    Ideas?

  • Community member Profile Picture
    on at
    Re: Google Drive error

    Sorry you ran into this issue!  Insert row for Google Drive is slightly confusing, because in reality it only works for Google Sheets.

     

    We just released a new Google Sheets connector, which you can use.  Let us know if that works out better for you.

     

    For any Excel spreadsheet (in Google Drive as well), select the Excel connector.  Once you select the Excel connector, you can change the connection to select the underlying connection (Google Drive).

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard