Mar 16 2020 06:34 AM
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...
Jun 25 2020 04:50 AM
@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
Jun 25 2020 06:37 AM
@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:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Jun 25 2020 07:08 AM
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
Jun 25 2020 07:24 AM
@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
Jun 25 2020 07:36 AM
Jun 25 2020 07:44 AM
Jun 25 2020 07:52 AM - edited Jun 25 2020 07:54 AM
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