I have a very simple form created in Microsoft Forms (one free text question). I am trying to create a simple Flow that will take the answer to the question, and the responder and insert these details into a new item in a SharePoint list. In the SharePoint list, the "created by" column is always populated by my account (as the flow creator) and not with the responder to the original Form - so in the Flow I'm trying to populate a person picker field with the responder of the original Form. In doing so it appears I'm only able to use the "Responder's email", and when trying to populate a person picker field with this, it fails. I am able to populate a single text field with the responder's email, but I need to populate a person picker field, as I will have a Powershell script that runs on this data and I need tog et further information about who the user is.
Can somebody please let me know how I can achieve this please. I'm new to Flow/Forms and thought this was going to be very simple!
Could you please share a screenshot of your flow's configuration?
Could you please show a bit more about your SharePoint list?
Could you please show a bit more about the error message?
Futher, do you want to populate a custom Person or Group type column with the Responder of the original Form?
I have created a SharePoint list on my side and the data structure of it as below:
Note: The Product Name column and Product Area column are both Single line of text type column, Product Date column is Date type column, the Responder column is a Person or Group type column.
I have made a test on my side and don't have the issue that you mentioned. My flow's configuration as below:
The flow works successfully as below:
If you want to populate a Person or Group type column with "Responder's email" dynamic content, please make sure that the Responder of your original form is a member of your Office 365 organization or group (or SharePoint group). If the responder doesn't exist in your Office 365 organization or group (or SharePoint group), the "Responder's email" dynamic content could not be filled within your custom person picker field (Person or Group type column).
Thanks for your response
I (the form & flow creator) was the responder. It only fails when I use the Responder's email to set the person picker field - when I send the resp[onder's email to a single text field it works fine.
Here's my Flow ...
Here's the error message (part 1):
Hi JojenReed & Kris,
Same issue here. Unable to populate "Person or Group" column type in SharePoint Online with the Forms' Responder's Email
Something new ? 🙂
Is it possible the other way around? Submitting a Microsoft Form from data in a sharepoint list (or excel table maybe)
Speakers, submit your sessions now! Call for speakers ends Feb. 10!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!