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 / Use SharePoint List as...
Power Automate
Answered

Use SharePoint List as a list to pass through Variables into Web Automation

(0) ShareShare
ReportReport
Posted on by 52

Godo morning!

 

My apologies to the community. I'm new to this tool and might not fully understand the lingo. I do have a coding background and have performed quite a bit of web automation - but never through PAD.

 

We are looking to create the following workflow - 

 

(This part is completed)

 

  1. Users complete an MS Form to submit their request for access to an LMS. A web flow is initiated when the form is submitted and dumps the information into a SharePoint List and sends an email to the administrator of the tool to add the new user to the web-based LMS platform.

(This part is not completed)

 

  1. We need to create an 'instant' cloud flow when the above step is completed that will pull all of the information in the row from the SPO list (created in the step above) and bring it into PAD so that we can use those fields as variables to pass through form filling web automation (creating an account in the LMS). 
  2. Send the new user an email with a confirmation that they were added and instructions on how to use the new tool.

 

I have a premium account for the purposes of calling a PAD flow from a Web Flow (which requires a premium subscription). I'm not sure how to get the data from the SPO list into PAD and then perform the web automation. To my knowledge, there isn't action like in Power Automate that 'gets' data from an SPO list in PAD. 

 

Does anyone have any idea how to set this up successfully? Is this possible with PA and PAD?

I have the same question (0)
  • Gidi Profile Picture
    601 on at

    Hi,

    have you already tried to use in Power Automate Desktop an input variable from type list and provide the list data from calling cloud flow?

  • Kmmille25 Profile Picture
    52 on at

    Hi Gidi,

     

    I'm not sure how that would look in PAD. Is there a way I could set that up to test it?

  • Verified answer
    Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    Hi @Kmmille25 ,

     

    Store MS Form values to Excel(One Drive) then call the Desktop Flow. Now read Last Row in from excel and update to Web Page.

     

    Let me know if this works for you.

     

    Regards

    Kaif

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 July 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 2

#2
trice602 Profile Picture

trice602 160 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 142 Super User 2026 Season 2

Last 30 days Overall leaderboard