Using Insert row action of Google Sheets connector >How can I load files I have

박아람 6

24723-fireshot-capture-208-%E1%84%92%E1%85%B3%E1%84%85%E1%85%B3%E1%86%B7-%E1%84%86%E1%85%A1%E1%86%AB%E1%84%83%E1%85%B3%E1%86%AF%E1%84%80%E1%85%B5-power-automate.png

Hello,

I tried to make new flow with tmeplate : https://asia.flow.microsoft.com/ko-kr/galleries/public/templates/0a5543d0ebef11e68d2ddfad08ce110c

When I try to connect Google Sheets, I can find only several sheets I have, not all files.

How can I choose or load specific files I have?

Thanks in advance.

1 answer

Pramod Valavala 20,636 Reputation points Microsoft Employee

2020-09-15T13:01:58.013+00:00

Clicking the > should browse into the root folder of your google drive. Since its a Google Sheets related action, only sheets are shown here.

Could you share more details on what other file you are trying to load?
Please sign in to rate this answer.
박아람 6 Reputation points

2020-09-16T07:24:23.693+00:00

Thank you for your answers.

When I click > button, I can't see any root forders in google drive... only several google sheets in my drive are shown.

I don't know the standard or logic.

Pramod Valavala 20,636 Reputation points Microsoft Employee

2020-09-16T07:47:37.813+00:00

By root folder, I mean the main folder where all your files reside in Google Drive. You should see only sheets or folders, which is expected.

Could you share what other type of file you are trying to select and why? If your intent is to work with all types of files, then you would want to use the Google Drive Connector instead.

Pramod Valavala 20,636 Reputation points Microsoft Employee

2020-09-21T04:59:45.58+00:00

@박아람 Just following up to see if my responses here help

박아람 6 Reputation points

2020-09-21T05:04:46.31+00:00

Thank you for your answers.

I understand only 'sheets' are visible in this folder.

What I mean is only several, specific sheets are shown, not all.

I tried to connect with the sheets, and some sheets are not found on the folders...

Pramod Valavala 20,636 Reputation points Microsoft Employee

2020-09-21T10:56:49.907+00:00

Could you confirm if they are all google sheets and not excel docs (which I can confirm don't work)? Also, the files have to be in your drive and not links to shared files (which I can confirm doesn't work either).

박아람 6 Reputation points

2020-09-23T04:14:24.837+00:00

It's all google sheets, not excel, docs or something else. I always work on google sheet so I have so many google sheets.
And also files that I have "in" my drive not shared or linked... I already checked those points...
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Using Insert row action of Google Sheets connector >How can I load files I have

1 answer

Your answer