Answered

[Google Drive - Insert row] does not work as expected

(0) Share

Report

Posted on by JerodJ

I'm exploring our Cloud Driver's compatibility with Microsoft Flow and things seem promising so far. However, there appears to be an issue with the [Google Drive - Insert row] action. When using [Excel - Insert row], I have the option of mapping the outputs from the previous action to the columns in the noted table in the Excel sheet:
Excel - Insert row

Unfortunately, I don't have the same option when attempting the [Google Drive - Insert row] action. Is this a bug, or should I be doing something different when trying to insert a row into an Google Spreadsheet?

Google Drive - Insert row

Categories:

Using connectors

All responses (3)

Answers (1)

Sort by

Samuel Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I also would have expected them to have similar behavior. @SameerCh, is this a known limitation with the Google Drive connector?
Verified answer

JS-27041152-0 on at

Like
a
(1)

Report
Copy link

Link copied!

No, it should work the same way (see below). If you sheet is empty, however, nothing will be shown. The connector assumes the first row as the column headers.
JerodJ 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the clarification. I didn't have any labels in the first row, so the Google Drive connector was unable to interpret and columns.