web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Iterate over a SharePo...
Power Automate
Unanswered

Iterate over a SharePoint list to automate data entry into a desktop app

(0) ShareShare
ReportReport
Posted on by 8

We're looking around at various solutions that would help us automate data entry into a desktop point of sale (POS) application on Windows. Before I go too deeply down the rabbit hole, I wanted to ask the community for a quick sanity check whether what we'd like to do is even feasible.

We have a SharePoint list with each row containing fields that need to be entered into a form in our POS application. 

 

We were wondering if we could use PAD to iterate over each row of the SP list directly, to grab the field values and enter them into our POS app? I can't seem to find any examples of iterating over a native SharePoint list - I see lots of examples using Excel though.

 

Am I SOL? Or do we have to rely on some awful scraping strategy to grab the data out of the SharePoint list table html?

 

Any suggestions or advice appreciated, thanks!
Bob

I have the same question (0)
  • vaibhavtandon87 Profile Picture
    182 on at

    I guess PAD doesnt have an action to get data from SharePoint directly and scrapping screen may not be the best solution. But you may want to use MS - flows to connect and get data from SharePoint in excel  and then use PAD to push that excel data to POS. Could be a longer a method. Thanks!

     

  • Daniel_Pa Profile Picture
    244 on at

    Hi Bob

     

    You could use the "Extract data from webpage" to extract the table data from SharePoint.

    If you're willing to venture outside of PAD, Power Automate has native connectors to SharePoint, which would allow you to extract the data directly and pass it onto a Desktop flow.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 248 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 204

#3
Haque Profile Picture

Haque 179

Last 30 days Overall leaderboard