Unanswered

Cannot find SiteAssets folder in Workbook Library for Run Script Excel Connector

(0) Share

Report

Posted on by mrd2023

Context: I'm trying to set up a flow using the "Run Script from SharePoint library" connector on a file stored in the SiteAssets/SitePages/ directory within a SharePoint site.

Issue: When I specify the SharePoint URL in the "Workbook Location" field (which the connector accepts), the SiteAssets directory does not appear in the "Workbook Library" dropdown and so I cannot select the relevant workbook (from "Workbook").

Sharepoint SiteAssets.png

Steps Attempted: I've tried getting the ID from the URL for the folder the file is in - but by inputting this the connector gives an error saying the "Drive ID is not valid" (paraphrasing).

Is there anything else I can do?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@mrd2023 you can try getting Drive Id of Site Assets library, to get the drive id, you can follow steps from this post https://powerusers.microsoft.com/t5/Building-Flows/Get-drive-id-for-Doc-Library-selection/m-p/856932/highlight/true#M120083

Was this reply helpful? Yes No
mrd2023 2 on at

Like (0)

Report

Thanks Anna - I did attempt the solution linked above, but my knowledge of REST APIs and JSON responses isn't great so was unable to get the IDs. In truth it will be easier for me to move the file to a visible part of the Sharepoint directory.

More importantly, the script I was hoping to run will currently not work, so I have had to pause development on this solution for now.

Was this reply helpful? Yes No