Hi All,
Not sure whether I'm in the right place on the forum. If not can someone signpost me please.
I'm trying to import 'all files in a given folder' as a Source for a PowerQuery. I can do that if the folder is local, but I want to do it from our organisation's sharepoint site so that others can use the PQ.
If I do Source = Files.Folder (" <pathname>") with a sharepoint folder path starting https:// then I get an invalid pathname diagnostic. I guess Files.Folder expects a local pathname.
If I do Source = Web.Contents(" <pathname>") then that seems to be accepted but then I run into an authentication issue. I have selected Organisational Account and signed in with my corresponding username. But keep getting the authentication failure when I try to connect.
What am I doing wrong? Or am I trying to do the impossible?
Thanks,
Andy
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
48 | |
18 | |
14 | |
12 | |
12 |
User | Count |
---|---|
61 | |
41 | |
24 | |
22 | |
19 |