SharePoint list to Microsoft Form

Question

Can you create a Microsoft Form from a SharePoint list?

E.g., I would like to use Microsoft Forms to send a survey to a group of people to allow them to review data and cast a vote to approve or deny a request based on that data. I would like to feed that form with data collected and stored on a SharePoint list.

Does this capability exist?

Answer 1

Dear Steven,

I'm afraid that the feature isn't available in Microsoft Forms now. You can't create a form from a SharePoint list in Microsoft Forms. You can only import data from Microsoft Forms to a SharePoint Online list by Power Automate.

The alternative way is to create a canvas app form by Power Apps connected to the SharePoint Online list.

Here is a demo for your reference.

Your original SharePoint Online list is as follows.

Create a gallery showing the list items and add checkboxes and a dropdown box for group members to update Approve or Reject.

You can type ["Approve","Reject"] in the dropdown box.

Create a button Update Items and type the following formula.

ForAll(RenameColumns(Filter(Gallery1.AllItems,Checkbox2.Value=true),"ID","ID1"),Patch(RequestList,LookUp(RequestList,ID=ID1),{'Approve or Reject':Dropdown2.Selected.Value}))

Create a button Reset checked items for users to uncheck all selected items and type the following formula.

UpdateContext({varResetCheckbox:true});UpdateContext({varResetCheckbox:false});

Type varResetCheckbox in Reset on the checkbox in the gallery.

Result:

You can embed the app on a SharePoint page with the Power Apps web part or send the app link to the group members to review and update the data to the SharePoint Online list.

Meanwhile, as our product developers are willing to hear the users' suggestions, I kindly suggest you submit your feedback on the Feedback platformto our product developers so that they can know your requirements and ideas for product improvements.

Thanks for your understanding and have a nice day!

Sincerely,

Cliff | Microsoft Community Moderator