SOLVED

SharePoint List embedded with Microsoft Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-3066316%22%20slang%3D%22en-US%22%3ESharePoint%20List%20embedded%20with%20Microsoft%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3066316%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20fairly%20confident%20this%20is%20not%20an%20option.%26nbsp%3B%20But%20wanted%20some%20community%20input%20on%20the%20matter.%20When%20creating%20a%20Microsoft%20Form%20I%20would%20like%20to%20use%20an%20already%20existing%20SharePoint%20List%20as%20a%20dropdown%20box%20as%20potential%20answers%20to%20a%20question.%26nbsp%3B%20I%20can%20see%20a%20lot%20of%20potential%20uses%20internally%20for%20something%20like%20this.%26nbsp%3B%20My%20current%20workaround%20is%20to%20ask%20people%20to%20provide%20the%20unique%20title%20for%20the%20SharePoint%20list%20item%2C%20which%20works.%20But%20it%20would%20be%20nice%20to%20allow%20people%20not%20to%20have%20to%20look%20that%20up%20and%20be%20able%20to%20load%20a%20list%20of%20options%20from%20a%20specific%20SharePoint%20list.%26nbsp%3B%20%26nbsp%3BThe%20best%20example%20I%20can%20give%20is%20a%20Manager%20Filling%20out%20a%20form%20as%20it%20pertains%20to%20one%20of%20their%20employees.%26nbsp%3B%20Right%20now%20I%20ask%20the%20manager%20in%20a%20text%20box%20to%20provide%20me%20with%20the%20employee%20ID.%26nbsp%3B%20It%20would%20make%20more%20sense%20if%20I%20could%20use%20a%20dropdown%20list%20with%20all%20the%20employees%20they%20managed%20already%20listed.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3066316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I'm fairly confident this is not an option.  But wanted some community input on the matter. When creating a Microsoft Form I would like to use an already existing SharePoint List as a dropdown box as potential answers to a question.  I can see a lot of potential uses internally for something like this.  My current workaround is to ask people to provide the unique title for the SharePoint list item, which works. But it would be nice to allow people not to have to look that up and be able to load a list of options from a specific SharePoint list.   The best example I can give is a Manager Filling out a form as it pertains to one of their employees.  Right now I ask the manager in a text box to provide me with the employee ID.  It would make more sense if I could use a dropdown list with all the employees they managed already listed.  

1 Reply
best response confirmed by pwintert (New Contributor)
Solution

@pwintert there is no way to pre-populate anything in Forms with data from a SharePoint list, spreadsheet etc. There are plenty of requests for it on the Microsoft Feedback Portal here.

 

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