Answered

Reading a Sharepoint list from a Desktop Flow

(0) Share

Report

Posted on by Mark A Stewart

I have a Desktop flow that reads through an excel file and updates a website, but now I would like to move the data in the excel file to a Sharepoint list.

My problem is I can't seem to find a way to read the Sharepoint list from a Desktop flow.

Am I missing something?

Categories:

Using flows

All responses (6)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mark_Stewart,

Maybe you could try the approach of using an invoke a web service action and use the REST API of SharePoint.

Below is an example of that.
JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Expiscornovus

I have received syntax error for the URL. Hope to receive your help!
GhitaFjorback1 69 on at

Like
a
(0)

Report
Copy link

Link copied!
Use m365 CLI! this is genious for all kinds of stuff with sharepoint, Teams etc. from PAD! 🙂

1. install nodejs https://nodejs.org/en/
2. Install CLI via cmd
npm install -g @PnP/cli-microsoft365

3. Run command
set-ExecutionPolicy RemoteSigned -Scope CurrentUser

And then you are set to go!

Example:
Use a powershell action in PAD with command

m365 login --authType password --userName %Username% --password %Password%; m365 spo listitem list --title "%SharepointListName%" --webUrl https://%Tenant%.sharepoint.com/sites/%site% --fields "%All the columns you want from your list, seperated with comma%" --output json; m365 logout

Or wait a little longer... Microsoft has announced future connections to sharepoint from PAD. 😉
JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you have an idea when they will have Sharepoint connection to PAD? On a side note, I am aware of Microsoft's announcement that Dataverse connection in PAD could be around Dec 2021.
GhitaFjorback1 69 on at

Like
a
(0)

Report
Copy link

Link copied!

I was with the understanding that PAD would get same connectors available as already available in flow as by Dec 2021, but now you mention only Dataverse, I am affraid this is all. 😞
Simona Bushevska 58 on at

Like
a
(0)

Report
Copy link

Link copied!

I get status code 401, do you know what is the issue, I tried to fix it with the http authentication in the advanced part but it doesn't work. Thank you in advance! 🙂