Edit excel in private sharepoint folder

[ratr]

I am trying to set up a flow where submitting an answer in microsoft forms automatically updates an excel-document in sharepoint.

I have managed to update excel-documents in a public folder on our sharepoint, but not in out private folder. It does not show up as an option under "location" - "document library" when making the flow. 

Is there a way to update an excel document (which I have access to) in a private sharepoint folder?

[v-xiaochen-msft]

Hi @ratr ,

You could enter the path manually.

Best Regards,

Wearsky

[ratr]

I tried to do that, but I might have done it wrong. Is there some trick to writing the manual path to a sharepoint folder?

[v-xiaochen-msft]

Hi @ratr ,

I just copyed and pasted its path...

Best Regards,

Wearsky

[ratr]

And then selected (as I need)

Excel -> Add a row into table ->

Location: SharePoint Site - My department

Document Library: "Enter custom value" : dynamic content -> paste weblink?

This results in the link being too long cutting it off fairly early (like https mycompany.sharepoint.com/:e)

The next step of selecting "file" also gets an error message by doing this.

it there a different way to get "the path" to the sharepoint folder? Or a different place to paste it?

[v-xiaochen-msft]

Hi @ratr ,

Don't copy the file web link. It's not the true file path.

If the file is shared with you , you could find it in onedrive and you could get the true path there.

Sample:

wearsky is the site name.

TestGG is the library name.

So what I want is '/CCC/Book.xlsx'

Best Regards,

Wearsky

[ratr]

Ok now we are getting somewhere nice. One difference is that the "library name" for me is the private department folder.

I have found the details -> path. But if I click the copy button, it gets the weblink again.

But the path looks something like this

Department > Privatedocuments > main folder > my folder > exceldocument.xlsx

So I try pasting it into the Document Library selection as:

Department/Privatedocuments/main folder/my folder (both with and without the excel link)

, but the same error shows up:  {"status":400,"message":"The parameter 'drive' has an invalid value [foldernames]}

Where am I stupid?

[H040150]

Hi guys, I currently have the exact same issue. My SP library is from a Private Group and the document I need is in the map 'Shared with us'. Any way to access the document? I have use rights to the document only, not the whole path.

Whenever I copy my link, it is: https://sharepointexample/:x:/s/BENPSKchannel/EcBeg4vG2TlGiawk3A-ODEoBQKTsXXXX-pXbUbAg32kdQ?e=qkxTck

I delete the e= & everything after that but it doesn't show my paths. It keeps giving me the drive invalid value issue?