Getting data from Sharepoint table/list to MS Forms

[JohndeLance]

Is it possible to get data from Sharepoint table or list to MS Form and how that can be done?

[#2]

@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)

[#3]

@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?

[#4]

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.

[#5]

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?

[#6]

@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)

[#7]

@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

[#8]

@philipwilliams a less expensive option might be to go for a per app license: https://learn.microsoft.com/en-us/power-platform/admin/about-powerapps-perapp

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