Unanswered

How can I link Sharepoint to SAP through Power Automate

(0) Share

Report

Posted on by Stassy

Hello,

I am trying to "get items" from a sharepoint list in power automate desktop, so I can get the information saved in the online list and upload into SAP. (I do have a Premuim account). Please HELP!

Thanks!

Categories:

Power Automate Desktop

All responses (7)

Answers (0)

Sort by

Unknown geen idee 1,757 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Stassy,
For me it works to have a OneDrive/Sharepoint synchronization setup on my local machine.
When I write items to this 'local' location, the sync-function ensures that these files/entries also get updated online.
Hope this makes sense to you, if you need any elaboration, please let me know.
Happy flowing,
Koen
Stassy 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear @Koen5,
I'm trying to get/read the information from a Sharepoint list, so that I can save it in different variables and upload it into SAP. The problem is I don't know how i can get the information from that list. I have tried with an SQL connection and "Invoke web services", but it doesn't work. Please HELP! (Maybe I'm putting some of the "code" wrong?)
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Stassy

Since you mentioned you have a premium account did you know that there is a whole bunch of SharePoint actions that can help you in this case
Stassy 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear @VJR,
I know that those functions and as far as i know, none of them let me retrieve the information of the items on the list. That is what I'm trying to achieve.
Unknown geen idee 1,757 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Stassy,

While I understand that you would like to do everything from 1 application (in this case PAD), one option to consider would be to get the list item details via Power Automate (cloud) and pass this one. View action below.

Hope the suggestion is useful,
Happy flowing,
Koen
Stassy 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear @Koen5 ,
I thought about that option, but how do i transfer the cloud information to PAD?
Unknown geen idee 1,757 on at

Like
a
(0)

Report
Copy link

Link copied!
Dear Stassy,
There are 2 ways (that I can think of):
You let PowerAutomate cloud save the details in a file in OneDrive, which you have auto-synced to your local computer and as such PAD can pick up the details.
You create an Input variable(s) with the PAD flow. Once you call this flow in PowerAutomate cloud, you will be prompted to provide input for these variables and as such you can pass on the data.
Hope this helps,
Happy flowing,
Koen