Unanswered

PAD flow for SharePoint List/Libraries

(0) Share

Report

Posted on by Rkmatieda

Hi All,

Please guide me to a solution where I want a PAD flow interacts with SharePoint lists and libraries. As part of a project, I need to interact with SharePoint list and its data.

The operations I want to perform are data extraction from the list, filtering of data rows depending upon conditions, adding new rows, and modifying some of the existing rows. So, all those actions that you can do with database. Also, the Web recording/automaton will be very inferior solution as it would take lot of time going through the records of such list (#rows could be in 1000s), So the preference would be some kind of backend data access of SharePoint.

Thanks in advance.

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

miketran13 720 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

If you don't need to interact with other applications except SharePoint list then I think you should you Cloud Flows instead of Desktop Flows. You should only use Desktop flows when you need to do a lot of actions on different applications on Window.

So, in your cases, I think you can just use Cloud flows for getting data from SharePoint List (of course, you can filter from cloud flows as well). Once you have your list items you can iterate all the items and can also add new item or modify the item if needed.

Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others
Rkmatieda 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi miketran13
Thanks for the reply and a good suggestion for Cloud flow.

But the solution does not only contain share point list. it also contains other platforms like SQL and some websites to scrap. In such situation you would like to have your entire solution to run on just one platform like Desktop flow. So, I am not the opinion to break the entire logic in two part i.e. Cloud and Desktop flow.
HebbyHebz 44 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you find a way around this? Would love to know how you did.

Meanwhile, Microsoft will be releasing the SharePoint connector for PAD soon. 👇🏾
https://docs.microsoft.com/en-us/power-platform-release-plan/2022wave2/power-automate/use-sharepoint-connector-power-automate-desktop