In my PAD flow, I need to open an Excel file that is stored on SharePoint. Using the standard "Launch Excel" action in PAD, I can't come up with a document path that works. I have tried navigating to the Excel file in SharePoint, opening the file in my desktop app, copying the path form the File/Info screen (taking out the ?web=1 part)... but the "Launch Excel" action doesn't seem to like it. Suggestions???
Solved! Go to Solution.
You have multiple options:
Finally found a solution. Kudos to John_A at this Q&A.
In PAD, to read an Excel file stored in SharePoint or OneDrive, figure out the path as described in the original question... but since PAD is sensitive to percent signs... escape any percent signs in the path with an additional percent sign. Problem solved.
So many little things to learn... sigh...
You have multiple options:
Thanks for the response. Good list of options. My thoughts/experiences with each:
Again I really appreciate you sharing these options.
Sync: After login you can open OneDrive and check/loop until the "completely synced" status message appears
URI Scheme: Right, then this might not work
Cloud Flow: Why do you want to still use PAD? Cloud flows is much more powerful with Excel
Sync: might work. More effort than I hoped.
Cloud Flow: overall goal is to suck data from a particular cloud service that does not have an API. Only means of pulling data is via their Excel Add-In. PAD does this very well except for a few quirky issues like the one I raise here...
Finally found a solution. Kudos to John_A at this Q&A.
In PAD, to read an Excel file stored in SharePoint or OneDrive, figure out the path as described in the original question... but since PAD is sensitive to percent signs... escape any percent signs in the path with an additional percent sign. Problem solved.
So many little things to learn... sigh...
Adding to this old thread for future users:
The accepted solution (a leading % to escape the metacharacter) still works in PAD.
It appears that another option for escaping metacharacters is to enclose the desired literal in double quotes. Example from my use: Launch Excel action, with the path as: https://<<server>>/sites/SiteName/Shared''%''Documents/rest_of_path
User | Count |
---|---|
13 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
20 | |
17 | |
17 | |
13 | |
12 |