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?

7 Replies

  • philipwilliams's avatar
    philipwilliams
    Copper Contributor
    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

      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

        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

         

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    JohndeLance you can't programmatically get data from a SharePoint list into Forms as Forms has no way of connecting to other apps. So you can't use Power Automate as there is no Forms trigger or actions for getting list data and adding them into a Form. All you can do is a copy & paste of a list column into a choice question in Forms.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

    • JohndeLance's avatar
      JohndeLance
      Copper Contributor

      RobElliottAlright. The purpose would be to make a simple web form with easy-to-maintain product information and prices. With the form, the user selects the product and quantity, and sending the form adds the selected products to Sharepoint or send an email.

       

      Can you tell me where I can start to make such an implementation?

      • ssmolen42's avatar
        ssmolen42
        Copper Contributor
        Power Automate, using the Forms submission trigger. You can take the response data and using the SharePoint or Outlook connectors, either embed that data in an email or create a new list item with it.

Resources

OSZAR »