Unanswered

Edit excel in private sharepoint folder

Like (0) Share

Report

Posted on 2 Jun 2022 07:12:36 by 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?

All responses (7)

Answers (0)

H040150 70 on 13 Mar 2024 at 08:58:11

Like (0)

Report

Re: Edit excel in private sharepoint folder

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?
ratr 6 on 07 Jun 2022 at 08:43:00

Like (0)

Report

Re: Edit excel in private sharepoint folder

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?
v-xiaochen-msft on 07 Jun 2022 at 08:06:35

Like (0)

Report

Re: Edit excel in private sharepoint folder

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 6 on 07 Jun 2022 at 07:48:25

Like (0)

Report

Re: Edit excel in private sharepoint folder

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 on 07 Jun 2022 at 05:21:57

Like (0)

Report

Re: Edit excel in private sharepoint folder

Hi @ratr ,

I just copyed and pasted its path...

Best Regards,

Wearsky
ratr 6 on 07 Jun 2022 at 05:05:21

Like (0)

Report

Re: Edit excel in private sharepoint folder

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 on 06 Jun 2022 at 02:31:13

Like (0)

Report

Re: Edit excel in private sharepoint folder

Hi @ratr ,

You could enter the path manually.

Best Regards,

Wearsky