Forum Discussion
JohndeLance
Dec 28, 2022Copper Contributor
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?
RobElliott
Dec 29, 2022Silver 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)
- JohndeLanceDec 30, 2022Copper 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?
- ssmolen42Jan 06, 2023Copper ContributorPower 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.