SHAREPOINT TO FORMS??

%3CLINGO-SUB%20id%3D%22lingo-sub-1230651%22%20slang%3D%22en-US%22%3ESHAREPOINT%20TO%20FORMS%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1230651%22%20slang%3D%22en-US%22%3E%3CP%3EOkay%2C%20so%20obviously%20most%20of%20us%20on%20here%20have%20pulled%20data%20from%20Ms%20Forms%20into%20their%20sharepoint%20list%20for%20whatever%20reason%2C%20but%20I%20want%20to%20do%20the%20reverse%2C%20or%20so%20to%20say.%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20use%20a%20lookup%20column%20from%20a%20sharepoint%20list%20as%20a%20dropdown%20item%20in%20Ms%20Forms%3F%3CBR%20%2F%3ESay%2C%20I%20have%20a%20list%20of%20projects%2C%20and%20my%20form%20takes%20column%20projectID%20and%20shows%20it's%20contents%20as%20a%20dropdown%20menu%20while%20filling%20in%20a%20form%20for%20a%20certain%20project%20step.%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20if%20you%20could%20suggest%20a%20better%20way%20of%20doing%20this...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1230651%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1488754%22%20slang%3D%22en-US%22%3ERe%3A%20SHAREPOINT%20TO%20FORMS%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1488754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F583147%22%20target%3D%22_blank%22%3E%40kebana%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20issue%2C%20I%20want%20to%20send%20a%20Form%20out%20to%20an%20external%20user%20with%20the%20information%20captured%20in%20a%20SharePoint%20List.%3C%2FP%3E%3CP%3EBut%20I%20would%20like%20the%20external%20user%20to%20be%20able%20to%20populate%20on%20the%20of%20the%20columns%20in%20my%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20receive%20any%20feed%20back%20if%20this%20was%20possible%2C%20or%20does%20anyone%20have%20any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EClaire%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1488980%22%20slang%3D%22en-US%22%3ERe%3A%20SHAREPOINT%20TO%20FORMS%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1488980%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F125762%22%20target%3D%22_blank%22%3E%40Claire%20Allen%3C%2FA%3E%26nbsp%3Bit%20isn't%20possible%20to%20use%20the%20data%20from%20a%20SharePoint%20list%20in%20your%20form%2C%20but%20you%20seem%20to%20want%20to%20capture%20the%20information%20from%20the%20form%20into%20the%20SharePoint%20list.%20This%20is%20very%20straightforward%20with%20a%20flow%20in%20Power%20Automate.%20At%20its%20simplest%20the%20flow%20looks%20like%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-flow.png%22%20style%3D%22width%3A%20584px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201012i7488BE00F5B9C7FC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%221-flow.png%22%20alt%3D%221-flow.png%22%20%2F%3E%3C%2FSPAN%3E%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%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489132%22%20slang%3D%22en-US%22%3ERe%3A%20SHAREPOINT%20TO%20FORMS%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489132%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20coming%20back%20to%20me.%3C%2FP%3E%3CP%3EThat%20won't%20work%20for%20me%2C%3CBR%20%2F%3EI%20have%20a%20SharePoint%20list%20that%20my%20internal%20users%20add%20data%20to%2C%20I%20have%20created%20a%20flow%20that%20triggers%20to%20an%20external%20company%20an%20email%20with%20this%20Data%2C%20what%20I%20then%20want%20is%20for%20this%20external%20company%20to%20email%20me%20back%20the%20Job%20Ref%20and%20my%20SharePoint%20List%20to%20get%20updated%2C%20hence%20why%20I%20wanted%20my%20SharePoint%20List%20to%20pre-populate%20the%20MS%20Form%2C%20and%20maybe%20the%20external%20user%20could%20just%20enter%20data%20in%20the%20one%20field%20required%20from%20them.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20flow%20that%20I%20have%20created%20works%2C%20but%20just%20can't%20find%20away%20to%20capture%20%2F%20export%20one%20field%20that%20the%20external%20users%20completes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EClaire%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489217%22%20slang%3D%22en-US%22%3ERe%3A%20SHAREPOINT%20TO%20FORMS%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489217%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F125762%22%20target%3D%22_blank%22%3E%40Claire%20Allen%3C%2FA%3E%26nbsp%3Bthere's%20no%20way%20to%20capture%20one%20or%20more%20fields%20from%20a%20SharePoint%20list%20to%20use%20in%20a%20Form.%20With%20Forms%20Pro%20I%20believe%20you%20can%20use%20CDS%20to%20create%20variables%20but%20I%20don't%20have%20Forms%20Pro%20so%20have%20no%20idea%20how%20that%20works.%20But%20nothing%20like%20that%20is%20do-able%20with%20standard%20Forms.%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%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489254%22%20slang%3D%22en-US%22%3ERe%3A%20SHAREPOINT%20TO%20FORMS%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489254%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20update%2C%20I'll%20look%20into%20Forms%20Pro%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3EClaire%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489302%22%20slang%3D%22en-US%22%3ERe%3A%20SHAREPOINT%20TO%20FORMS%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489302%22%20slang%3D%22en-US%22%3E%3CP%3EOnce%20again%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F493704%22%20target%3D%22_blank%22%3E%40Lewis-H%3C%2FA%3E%26nbsp%3Byou%20have%20not%20answered%20the%20question%20that%20that%20was%20asked%20but%20have%20given%20instructions%20for%20something%20totally%20un-related.%26nbsp%3B%20Why%20do%20you%20do%20that%3F%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%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489269%22%20slang%3D%22en-US%22%3ERe%3A%20SHAREPOINT%20TO%20FORMS%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489269%22%20slang%3D%22en-US%22%3EHover%20your%20mouse%20above%20or%20below%20an%20existing%20web%20part%20and%20you'll%20see%20a%20line%20with%20a%20circled%20%2B%2C%20like%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3EPlus%20sign%20for%20adding%20web%20parts%20to%20a%20page%3CBR%20%2F%3E%3CBR%20%2F%3EClick%20%2B%20to%20see%20a%20list%20of%20web%20parts%20to%20choose%20from.%20Click%20the%20Microsoft%20Forms%20web%20part.%3CBR%20%2F%3E%3CBR%20%2F%3EAdd%20to%20page%20button%20with%20Microsoft%20Forms%20web%20part%20selected.%3CBR%20%2F%3EAdd%20and%20publish%20a%20page%3CBR%20%2F%3EIf%20you%20don't%20already%20have%20a%20page%20with%20web%20parts%2C%20follow%20these%20steps%20to%20prepare%20one.%3CBR%20%2F%3E%3CBR%20%2F%3EGo%20to%20the%20site%20where%20you%20want%20to%20add%20a%20page.%3CBR%20%2F%3E%3CBR%20%2F%3EGo%20to%20the%20home%20page%20of%20the%20site.%3CBR%20%2F%3E%3CBR%20%2F%3ESelect%20%2B%20New%2C%20and%20then%20select%20Page.%3CBR%20%2F%3E%3CBR%20%2F%3ENew%20Page%3CBR%20%2F%3EAlternately%2C%20you%20can%20go%20to%20an%20existing%20page%2C%20select%20%2B%20New%2C%20and%20select%20Start%20from%20a%20blank%20page.%20Or%2C%20you%20can%20choose%20Copy%20of%20this%20page%20to%20create%20a%20new%20page%20that%20has%20the%20same%20web%20parts%20and%20content%20as%20the%20existing%20page.%3CBR%20%2F%3E%3CBR%20%2F%3EChoose%20a%20page%20template%20to%20start%20with.%3CBR%20%2F%3E%3CBR%20%2F%3ETemplate%20gallery%3CBR%20%2F%3EAdd%20a%20page%20name%20in%20the%20title%20area.%20A%20page%20name%20is%20required%20to%20save%20the%20page.%20See%20the%20Customize%20the%20title%20area.%3CBR%20%2F%3E%3CBR%20%2F%3EAdd%20web%20parts%3CBR%20%2F%3E%3CBR%20%2F%3EHover%20your%20mouse%20below%20the%20title%20area%20and%20you'll%20see%20a%20line%20with%20a%20circled%20%2B%2C%20like%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3EPlus%20sign%20for%20adding%20web%20parts%20to%20a%20page%3CBR%20%2F%3EClick%20%2B%20to%20add%20content%20like%20text%2C%20documents%2C%20video%20and%20more.%20To%20learn%20more%20about%20how%20to%20find%20and%20use%20web%20parts%2C%20see%20Using%20web%20parts.%3CBR%20%2F%3E%3CBR%20%2F%3EAdd%20to%20page%20button%3CBR%20%2F%3EYou%20can%20also%20add%20sections%20and%20columns%20to%20a%20page.%20To%20learn%20more%2C%20see%20Add%20sections%20or%20columns%20on%20a%20page.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20you're%20done%20editing%2C%20you%20can%20click%20Save%20as%20draft%20to%20save%20your%20changes%20and%20close%20edit%20mode.%20Your%20audience%20won't%20see%20the%20page%20until%20you%20publish%20it.%20Only%20people%20with%20edit%20permissions%20on%20your%20site%20will%20be%20able%20to%20see%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20you%20are%20ready%20for%20your%20audience%20to%20see%20the%20page%2C%20click%20Publish.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Okay, so obviously most of us on here have pulled data from Ms Forms into their sharepoint list for whatever reason, but I want to do the reverse, or so to say.

Is it possible to use a lookup column from a sharepoint list as a dropdown item in Ms Forms?
Say, I have a list of projects, and my form takes column projectID and shows it's contents as a dropdown menu while filling in a form for a certain project step. 

Or if you could suggest a better way of doing this...

 

7 Replies
Highlighted

@kebana ,

 

I have the same issue, I want to send a Form out to an external user with the information captured in a SharePoint List.

But I would like the external user to be able to populate on the of the columns in my list.

 

Did you receive any feed back if this was possible, or does anyone have any suggestions?

 

Thank you

Claire

Highlighted

@Claire Allen it isn't possible to use the data from a SharePoint list in your form, but you seem to want to capture the information from the form into the SharePoint list. This is very straightforward with a flow in Power Automate. At its simplest the flow looks like this:

1-flow.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott 

 

Thank you for coming back to me.

That won't work for me,
I have a SharePoint list that my internal users add data to, I have created a flow that triggers to an external company an email with this Data, what I then want is for this external company to email me back the Job Ref and my SharePoint List to get updated, hence why I wanted my SharePoint List to pre-populate the MS Form, and maybe the external user could just enter data in the one field required from them.

The flow that I have created works, but just can't find away to capture / export one field that the external users completes.

 

Thanks

Claire

 

Highlighted

@Claire Allen there's no way to capture one or more fields from a SharePoint list to use in a Form. With Forms Pro I believe you can use CDS to create variables but I don't have Forms Pro so have no idea how that works. But nothing like that is do-able with standard Forms.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott 

 

Thank you for the update, I'll look into Forms Pro

 

Kind regards

Claire

Highlighted
Hover your mouse above or below an existing web part and you'll see a line with a circled +, like this:

Plus sign for adding web parts to a page

Click + to see a list of web parts to choose from. Click the Microsoft Forms web part.

Add to page button with Microsoft Forms web part selected.
Add and publish a page
If you don't already have a page with web parts, follow these steps to prepare one.

Go to the site where you want to add a page.

Go to the home page of the site.

Select + New, and then select Page.

New Page
Alternately, you can go to an existing page, select + New, and select Start from a blank page. Or, you can choose Copy of this page to create a new page that has the same web parts and content as the existing page.

Choose a page template to start with.

Template gallery
Add a page name in the title area. A page name is required to save the page. See the Customize the title area.

Add web parts

Hover your mouse below the title area and you'll see a line with a circled +, like this:

Plus sign for adding web parts to a page
Click + to add content like text, documents, video and more. To learn more about how to find and use web parts, see Using web parts.

Add to page button
You can also add sections and columns to a page. To learn more, see Add sections or columns on a page.

When you're done editing, you can click Save as draft to save your changes and close edit mode. Your audience won't see the page until you publish it. Only people with edit permissions on your site will be able to see it.

When you are ready for your audience to see the page, click Publish.
Highlighted

Once again @Lewis-H you have not answered the question that that was asked but have given instructions for something totally un-related.  Why do you do that? The question had nothing to do with creating a SharePoint page or adding the Forms web part to it. 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User