Forum Discussion

JohndeLance's avatar
JohndeLance
Copper Contributor
Dec 28, 2022

Getting data from Sharepoint table/list to MS Forms

Is it possible to get data from Sharepoint table or list to MS Form and how that can be done?
forms
sharepoint
philipwilliams's avatar
philipwilliams
Copper Contributor
Aug 01, 2024
this would be so useful.
my use case is internal, and now that Sharepoint Pages has ended support for connectors, the simplest way for me to do what I want does not exist..
a dynamic link to update available selections in a form from Data would be perfect 😞

as I understand it, Power Automate can get the data out, but not feed any data in?
Rob_Elliott's avatar
Rob_Elliott
Bronze Contributor
Aug 01, 2024

philipwilliams "as I understand it, Power Automate can get the data out, but not feed any data in?" Yes, that is still the situation. Your best option is to look at a form in Power Apps connected to a SharePoint list as the datasource.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

  • philipwilliams's avatar
    philipwilliams
    Copper Contributor
    Aug 01, 2024

    Rob_Elliott 

    thanks Rob!

    that is something I've been working on,

    however it ran to a standstill when I was advised by our licensing team that each end use of my canvas app would need to apply for a Power Apps per-user license...

    (a cohort of over 1000 potential users - of which only a small number would be likely to use the app, and quite possibly only once)

     

    each user would need to complete an internal license request form, and have their manager agree to the cost, and approve the license.

     

    the barrier to entry is too high for the benefit of the app 😞

     

    unfortunately we are back to end users adding their data to a shared .xlsx

     

Resources