SOLVED

Can I pre-populate a Microsoft Form choice area with SharePoint list data?

%3CLINGO-SUB%20id%3D%22lingo-sub-2076531%22%20slang%3D%22en-US%22%3ECan%20I%20pre-populate%20a%20Microsoft%20Form%20choice%20area%20with%20SharePoint%20list%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2076531%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20data%20in%20a%20SharePoint%20online%20list%20that%20I%20would%20like%20end-users%20to%20choose%20from.%20I%20would%20like%20to%20pull%20that%20data%20into%20a%20Microsoft%20Form%2C%20as%20%22choice%22%20options%20to%20select.%26nbsp%3B%20If%20this%20is%20doable%2C%20how%20do%20I%20set%20something%20like%20this%20up%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2076531%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2077898%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20pre-populate%20a%20Microsoft%20Form%20choice%20area%20with%20SharePoint%20list%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077898%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F509342%22%20target%3D%22_blank%22%3E%40kensleylewis%3C%2FA%3E%26nbsp%3Byou%20can't%2C%20that%20functionality%20doesn't%20exist%20in%20Forms.%20To%20do%20this%20you'd%20need%20to%20create%20a%20form%20in%20Power%20Apps%20with%20the%20SharePoint%20list%20as%20the%20data%20source.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have data in a SharePoint online list that I would like end-users to choose from. I would like to pull that data into a Microsoft Form, as "choice" options to select.  If this is doable, how do I set something like this up?

1 Reply
best response confirmed by kensleylewis (Contributor)
Solution

@kensleylewis you can't, that functionality doesn't exist in Forms. To do this you'd need to create a form in Power Apps with the SharePoint list as the data source.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User