Forum Discussion
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?
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)
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
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)
