I've gotten multiple comments that the forms options are missing. Microsoft is currently testing out a new UI for Power Automate and the Almost all the forms items haven't been loaded into it yet. To build this flow you need to switch back to the old UI (same as the video) Toggle the New Designer Switch in the top right corner to switch the UI back. After you save your flow with the Forms Triggers and/or Actions they'll show in the new UI Thank you everyone for watching!
I'm using Power Automate for a help site SharePoint list and I have most my fields getting populated but I'm having an issue with attachments. I have the attachment upload in my form, and I have an attachment column in my list. When the form is submitted the fields do get saved into my one drive but for some reason I am unable to get Power Automate to recognize that field in the Power Automate flow interface. Any ideas on how to get attachments from the form to get picked up by the Power Automate flow and then added to the SharePoint list?
Are you use the new UI or the classic/legacy UI. When I tested the new ui I didn’t see the options for response ID. Damn beta or “public preview” products.
Like parse one submission and break it up into multiple items in the sharepoint list or back track in forms to grab other entries to create multiple items in SharePoint?
Thank you; very helpful! One question: I'm working with an already existing form. Is there anyway to get the previously submitted responses to show up on my newly created list or will it only capture anything that's submitted going forward?
With out having to sort out the complex logic of old and new. You could create a second manual flow to get the previous responses by date or other unique item and then process it the same way as the automated flow.
Thank you for the Video, may i know how can i create multiple records with separate date on every row in list when Microsoft form response has Start date and end date.
You would have to either match the start and end date from the form. Process the forms data in batches (once per day maybe) and establish a start date in the flow and use the time expression to increment by 1 day/interval while looping through the records.
How to do Automate Microsoft Forms Responses to teams, but I want to delete empty colums when the answer go to teams. For example, I have 5 questions in teams- 2 questions are left blank, so how do i only send the filled answers to forms?
I'm not 100% what you're asking here but I think the answer is using an If statement or in Microsoft Power Automate language, a condition. Basically, for each question check for if the answer field is blank or not. if it's blank terminate that step of the flow.
Hello & thanks for the great video. Is there a way to automate a form response into an EXISTING sharepoint list (where data/other previous entries already existed)? What would be the suggested unique Response ID to use? Thanks!
Response id is the unique id from the Microsoft forms side of it. You can port the data into an existing list. All you have to do match the form data to the correct columns in sharepoint.
Hi TD, I am having issues being able to map my list parameters from my list to my form. When I create item for my Sharepoint list, I find the file just fine but I have to click "Show all" next to Advanced parameters and then the fields show-up but they don't have drop downs for me to select the field to connect to. The only anomoly up to that point is I only see "List of response notifications Response ID" in my Get response details drop down. I don't see simply "Response ID". Any ideas?
I don't see any lookup fields in your List. Do you have a video addressing that? I pull responses from my form and I need to use "ID" when it's a lookup table. But I can't figure out what to put in there! the only reponse I have available is "ResponseID", which doesn't cut it.
Thanks for watching! This solution is built off of processing the form submissions as they come in and eliminate manual processing. Not bulk importing. For a bulk import you could create a manual or scheduled flow that loops through all the responses and if the response id matches the that an item in that column in sharepoint skip it, or handle it how you want it too. I don’t have a dedicated video for that but I’ll add it to my to do list. Thank you for the idea.
Thank you! Question- what if my form consists of selections (either 1 option or multiples)? I followed this video, but my SP list did not populate the selection columns, how would you approach this?
Is there any errors in powerautomate? This whole automation is just a fancy copy and paste. So if source and destination exist as long as they are linked it should go through.
This is super helpful, but I'm running into problems. It looks like my UI is slightly different (maybe and updated version). When I try to add the dynamic content, it's not giving me a drop down to choose the response details. How do I get this in the new UI?
The new UI is still in public preview so its incomplete. Switch back to the old UI in the top right corner and add the corresponding Forms triggers and actions. After you save it the forms items will be available in both UIs.
Great tutorial! When I create a simple flow like this, I do not see 'Response ID' on the 'Get response details' action item. I only see "List of response notifications...". Why?? Selecting this gives me a 'Apply to each' loop and I don't think I want that.
Automated photo processing in SharePoint is tricky because on the back end it's stored as binary data. It's easier to make a flow to store the photos in a document library and link it rather then attaching a photo to a list. Attaching a photo to a sharepoint list is effectively trying to insert a photo into an excel cell.
Unfortunately When I pressed "When a new response is submitted" and pressed ok, I tried to pick a response but it showed a message saying Invalid connection, please update your connection to load complete details" and I have no idea what that is about...it won't show the any form at all...
i need HELP! lol. so i followed your awesome video and after hitting connect creating the link between power automate and my forms i keep getting invalid connection, please update your connecto to load complete details. then form ID pick from form but there is nothing to pick from. i have no idea what im doing wrong. i changed my enviornments, ive logged out logged back in and just keep getting the same response....
Hello @ambermiranda The new UI is still in public preview so its incomplete. Switch back to the old UI in the top right corner and add the corresponding Forms triggers and actions. After you save it the forms items will be available in both UIs.
The excel spreadsheet is a query to the data. Which a sharepoint list you can build it into line of business processes and automations. Plus it can be easier to read on mobile devices. There is some overlap in functionality between the two.
Sugestions on how to send an email to the email address of the person submitting the form? I';m stuck at the 'To' line in flow. I put Mail and I get the email as the creator. I want the person submitting the form to receive a 'confirmation email' basically.,
For the to field you should be able to use a dynamic item for the responders email address or if it’s all internal then the user profile should have the info your looking for
You have to have permission to access the form or a service account that has access to the form and licensed for power automate. The video assumes either you created the form or a member of a group that did. To move a form, The owner of the form has to go to the form and under the 3 dots select move. Then the owner can move it to the underlying team's group to grant you access to it.
@@TDSheridanLab I do have permission. I actually moved the MS Form from under me, to under a Teams channel. I made a copy with a different name under me. I see the copy, I don't see the one I moved. This is been really helpful. You got a subscribe from me. And I will be sharing this. I am going to use Power automate more. You are the first to show me this tool. Thank you so much.
Hi Mr Sheridan. I have gotten to the end of this which was great, however I would like to have each a sequential reference number added to each update to Sharepoint list when a new form is submitted. Can you do this? Many thanks
Thank you for watching. To assign a reference number you have a couple of options. 1. can make a mathematical equation using the date and time in a calculated column. 2. in power automate you could sum up the total number of items and add 1 then write that to a column 3. Us the item is which starts at one. Each option has pros and cons depending on what you’re trying to do.
Great video! I keep getting the error 400 message: user not found for an old list. Idk where I went wrong because the mapping has been done perfectly and the datatype matches the input sent.
Hello. I want to receive the Ms forms responses in sharpoint having the number of response and the date of time of submission? How can I do that? I follow all your steps and all is good until now but I’m stacked on this issue. Could you please answer?
Since the flow is running at the same time as the responses are coming in. All you have to do is show the default created column in Sharepoint. The created timestamp in Sharepoint should be with in a few minutes of when it was created in forms.
Hi @TDSheridanLab, this is a great tutorial. When the record is added to SharePoint, it doesn't bring over the user who submitted the form in the 'Created' field in the SharePoint List. Is there a trick to this?
The created field is determined by who made the list item. Since the people who fill out your form probably don’t have access to the list or if it’s an anonymous form then the licensing can’t transfer. Also if you’re using a service account then the created field would show the service account. The best thing to do is to create additional column like “form submitted by” and update the flow to capture who submitted the form.
I'm less familiar with the Google eco system since Microsoft's is vastly superior 😉. So i'm unsure on how google is going to handle the file data and what is or isn't allowed in google sheets or google tasks. But from a high level you have to build out this workflow. When form is submitted -> get all the details -> get file content -> Create item in SharePoint -> upload data into sharepoint/attach to created item -> create item in google sheet/tasks -> upload attachment to drive/tasks etc. I would recommend if you're using Microsoft Forms as your Intake. Create a Team in teams and store everything in that team and invite any external people as needed. Its way easier to keep all of this data in sync when its on 1 platform instead of 2.
It's so annoying one every video i see when you are asked to chose a form there is a picklist with all these options, mine is always blank even though it says i'm connected to the email address that created that form. then subsequently even when i manually enter the form ID none of the fields appear when i try to map them using dynamic content, can anyone assist with this problem?
I paused your video at 8:43. What if one of the items on the form has many choices? For instance, my form has 1 question that gives 4 choices. How do I add this to populate in my list?
For choice fields you have 2 options. 1. In SharePoint you make the corresponding column a single line of text field and then use the Dynamic Choice Value in the Power Automate flow. 2. In SharePoint you make the corresponding column a choice field and mirror the values exactly. I usually stick with option 1 so if there is changes to the form, I only have to update the form and not SharePoint. Thanks for watching.
Good Question, If you're recording the submitted user in Microsoft Forms you can use a people column in SharePoint and the email address/User Principal Name as the claim in the power automate flow. Thanks for watching!
I can add the Dynamic Trigger ‘Response ID’ to the Response ID field. When I go to Create Item, I do manage to select the correct list so that my MS Form questions appear on screen. But I also cannot add in the questions to this field. They are not showing up to select them. Are both errors related? Thanks
Are you using the new power automate UI? It’s buggy and limited right now. Switch back to the classic/legacy UI to have all the options In the legacy/classic UI it should be linear once everything is connected. It sounds like you’re getting that far based off of the Response id part.
This video was released before that was an option in forms. But, you’d have to build out the logic to see if an entry was already in sharepoint or not as the first step. Then either create or update the record. Believe you could record the response ID from forms in sharepoint and search by that.
I don’t have a specific video for that, but you can make a simple flow to do that or build it on to the end the flow. The action to use is send an email. You may want to use a dedicated service account for notifications. Thanks for watching.
Awesome this helps alot! I tried adding a field for Attachments, mostly for images and when i ran the flow it all came back successful but no images in the column =( Any advice?
Hello! In my office we are trying to come up with a ticketing system to manage our workflow. A program like Power BI would probably be overkill for our needs. 3 of us process 20-40 action items a week, individually. We have between 3-5 different types of actions to manage. Someone has suggested that we use Microsoft Planner as a platform for this. I’m not sure that Planner is the best fit for our intended use. Rather than planning singular unique projects would need something to use over and over for repeat requests of the same type. I believe planner has been suggested for its relative ease of use. Could you tell me what comes to mind to serve this type of function?
Hello, Thank you for reaching out! Let's go through these items. Power BI is a reporting and analytics tool, so it won't help you keep track of the work. It will just make reports about the work. Planner is a lightweight project management solution that primarily uses a Kamban style approach. It can be very verbose within its feature set scope, but Microsoft made sure not to have it over run their stand alone paid for project management software, Microsoft Project. Planner competes directly with project like Monday.com. Overall, based on what you've said you need to scope the type or types of work you do and determine if a ticketing system with automation and scheduling capabilities is the best fit or a Project management solution that allows for templating and possible resource management. Most of my direct experience with ticketing systems is from an MSP point of view which is probably overkill for your current scenario. If I was in your shoes I would look into the following products. Ticketing Systems FreshDesk ZenDesk Project Management Tools Microsoft Project Monday.com ClickUp Then see which ones line up the best. If cost is the main driver, some of the options above have free options, but once you get into task and/or Project templating that usually interduces cost regardless of the platform. Thanks for watching
Great video! My only problem that I am facing now is that i am using the form to log employee training into the list, however if the employees wants to update their entry i want the already existing line to just be updated rather than a new line being added. Is this possible?
You’re trying to have an interactive form then I’d recommend using only a sharepoint list with item level permissions. To use forms and sharepoint you would build the intelligence in power automate to check to see if there is an item in sharepoint already and then how to modify the existing item.
@@TDSheridanLab Yeah sorry I am using SharePoint for the list, so I have set the form up, created the list in SharePoint and then done the power automate to link the two. i just can't figure out how to allow to link the two, i tried with the condition step but that didn't work. what do you mean by build the intelligence in power automate? I'm still very new to this sorry. Thank you for the hastily response though.
no worries, by "Build in the intelligence" mean design the logically processing to detect if there is an entry in SharePoint online. Lets say for example, the form is capturing the responder's e-mail address and there is only one response to the form per person and they make a change to the form. then the PowerAutomate side would have to work down a logic tree similar to this. Trigger: when a form is submitted or modified. Switch: is there a value in the responder column of SharePoint already? If No: Create item in SharePoint if Yes: Delete the item and create a new item with the current information. Basically, the most difficult part is determining what do to when a match is found. if it's a scenario where the most up to date information from Forms is the goal, then you can easily delete the original item and create a new with the newest information. On the other side if the SharePoint list is acting more like a worksheet or a mini database, you might not be able to delete the item and instead figure out what changed on the forms form and only update that one column value in SharePoint. In Power Automate, this would create a series If statements or switches for each column with the logic of "does the form value match the SharePoint value? Yes or No", If no update SharePoint from the forms data. I hope that clears things up.
Depends on your use case. 1. If this going to be for a new Line of Business Function, reach out to who's in charge of SharePoint for access. 2. You can use a Microsoft Teams Team The backend for Teams is SharePoint so when you build a flow you'll see a SharePoint site with the same name as the team. 3. You could use a personal Microsoft List. Microsoft Lists are just rebranded SharePoint Online Lists. You can create a personal list that is stored in your OneDrive if you're the only one that needs to access it.
you can but on the SharePoint side, you either have to: 1. have matching answer values in SharePoint 2. Convert the value from the form to a string value and store it in a text field on SharePoint. Thank you, for watching.
You can if the form is a one time use deployment or it you want to do this process manually each time. With Powerautomate it can be automated based on the activity of the form.
This video and flow is designed around a one and done scenario, like a contact us form that your not editing after your done submitting it. To accomplish this goal, you’ll have to record the response id in sharepoint. Then in a second flow you’ll have to build out the logic to search for the response id and if found update the fields accordingly.
great video! I am very new to power platform. I am trying to save a ms form into SharePoint following your video. it works fine except it is saving the flow owner ( myself) as the SharePoint created/modified by every time someone submits a MS form. How can I fix it ? Thank you!
You have a couple of options. But regardless that created by/initial modified by columns will be stamped with something. You just have to decide what the something is. 1. Create a business flow. Under a business flow the automation is run automatically behind the scenes can be shared with everyone that has access to the resources. Originally, if you needed 1 business flow the minimum you could purchase was 5 so you have spend $500 a month to get your foot in the door. Now they have a pay as you go options so you can buy 1 business flow and just pay for it when it runs. 2. Create a dedicated service account. Make it "Company/Department Automation bot" or something that says "Hey this is automated process" Without know your specific scenario, I tend to lend more towards option 2 if you license it with Power Automate plan 2 (or whatever they are calling it these days). Because then it can be the official automation account with access to the premium connectors. I hope that helps.
You have to create the word doc (not word template) and then modify this flow or create a new flow using the word actions. Some of the word actions like filling in word documents requires powerautomate plan 2 or higher licensing.
Mirror it on both side exactly or take the choice field from the forms form and put it to a single line of text field in sharepoint. in power automate make sure you the choice field section value option.
Hey, thanks for the video! I am very new to PowerAutomate (and Lists) so this was very helpful. I have what I think is a simple question/problem to solve, I just don't know how. I've created a Form that I've PowerAutomated to populate a Lists... In my form I have a "Date" selector question, that allows the user to select a date from a calendar. I've also created a list that I would like to auto populate from the Form. I cannot get the time to populate from the MS Form in the MS Lists (You are not able to select time in MS Form with the date selector). I am able to update the time automatically in the MS Lists, as the column format is "Date and Time". I would like to populate the date AND time through the PowerAutomate flow...is there a way you're aware of??? I'm struggling over here 😩😩😩 Thanks
Depending on what need the Date & Time field to do you have a couple of options. (More Compex) If you need the Date & Time field to remain that type of feature so you can do other time based items off of it then you'll need to clean the date/time field in powerautomate to covert it from forms into sharepoint time. There are multiple manual functions to do this, and they are adding additional plug and play options all the time. (Easier) If you don't need the date and time to be used as time and date and just need a reference, then i'd convert the field to string field in power automate.
Can we make another form link to this List column to update status. i e. Customers filled Rating Form which will update his record in list as completed. If Bad rating then needs to change status follow-up. Looking forward and thanks in advance.
It’s definitely do able, but you’ll have to figure out the logic to link rating survey back to the original entry in sharepoint. Scoping expectations to last work completed, you could use email address to link it all together.
Great video, first time using Power Automate. How can I set up a Microsoft Forms with Power Automate to limit the number of responses to a question? i.e. I would like only a certain number of respondents to respond to one question, if the max is reached, the question should not accept any more responses.
Thank you for watching. I don't believe that is possible. I haven't had to dive in that granular to forms. Everything I've done has been time based. Indirectly, you could use power automate to check the forms responses and then notify you that capacity has been reached.
Unfortunately, RU-vid doesn't allow for screenshots. That error is pointing to something that is invalid from a previous step. I'd make sure all of your dynamic items still valid if you added and removed actions while building. And make sure the data type from Microsoft Forms/previous lines up with the data type in the sharepoint columns/use expressions to convert data as needed.
This is great, I had the same problem as others which was solved from looking at the comments to change to old UI. Just one question, if there is a 'choice' question, do I need to do multiple flows as it only lets me select one? Thank you!
You don't need multiple flows, the easiest way to handle this is to make the SharePoint side a text column. So when a user chooses a value on the Forms side, Power Automate copies in that text value to SharePoint.
When you are creating the list, do all of the fields need to be generic text fields? I have a form that asks for people's names. Ideally I'd like to link this form to a corresponding list that uses a name field in order to reap the additional benefits of manipulating that type of data. Thoughts? Thanks for the video.
Text fields are the most flexible but are not your only option. For names, you can use look ups by email address or UPN to start linking responses to the actual user account (depending on set up). Rating systems can use the integer columns and formatting options. Then based off of the submitted information you can use SharePoint to do more with the data using calculated columns and make reports by piping the SharePoint list into Power Bi. It all comes down to the data you're trying to collect and what you're trying to do with it. Thanks for watching!
I had been working on this on my own for HOURS! Couldn’t not get the flow to run. I followed along with this video with minimal pausing and a few rewinds. I got it!!! This was super helpful! Thanks so much!
Hi this was very helpful. The only trouble I am having is that my status and notes fields aren't showing up when I click on the form like you did to add your notes and change the status
You would have to build out the logic of based on the options/values from the form, route it to a specific list. Or you can build out views in one list for the different functions depending on your situation.
Hello @luongthu5615 I just went through and testing building the flow again under the new UI. Everything is in the same spot as before but is displayed very differently. It looks like Microsoft is show more of the code items that were hidden more in the past. I'm perfectly fine with creating an updated video with the new UI, but I don't want it to be a carbon copy of this video. Is there any Power Automate, SharePoint, Forms, or other connected technology you'd like me to include?
Thank you, Also in Power Automate, you can go to the top right corner there is a 3 dot menu. In that 3 dot menu there is an option to switch back to the classic editor and this flow will can be built as directed in the video.
Yep, you can redesign it to take new responses and place them where Microsoft can access. For example, you can create a shared word document and append new response to the bottom or send a message to teams channel with the latest response. The sky is the limit with PowerAutomate.
Great tutorial, but I need to know the quiz score in addition to the start time to calculate the duration of the assessment. Is there any way to get this data?
I've never had to automate quiz answers into sharepoint before. Everything i've done has been static contact or feedback data. Off the top of my head i would thing that you'd have to isolate what is doing the grading of the quiz and then build the logic around that.
The title field can be anything that makes sense for your use case. When creating List views the title field has the options for edit and other items I try to use it as a unique value for the item. But if that isn't needed/wanted for your use case then don't worry about it.
Hey, I’m having an issue. As I follow your steps, I get stuck at the part when you’re creating a Sharepoint item. Everytime I put the url in in the Site Address, it keeps saying not found. Even when I click on the down arrow, it can’t find it. Do you have any advise on why this is the case?
That should be enough time. For the url are you copying the url up to the site name or the full url to the list. You only need the site url. once the site url is in, then powerautomate scans the site and picks up the available lists.
This is amazingly helpful! I’m wondering if this can be done again in reverse back to a new form to fill out for detailed responses to the initial form entry?
I just checked power automate and there isn't a new form action. This is probably because forms is designed to be an intake platform similar to survey monkey. So if you're looking to create a new form after SharePoint processes it. Then i would recommend to either build out the SharePoint side to handle the additional steps or look to export the results in a PDF or Word document.
The notes section is a "Multiple Lines of Text" column with "Append Changes" (version control) enabled. By default on all teams and modern SharePoint sites the underlying version control feature is enabled. If you're using an existing SharePoint site that was made a long time ago you may need to turn it on under the list settings. When you enable "Append Changes" on a text field, SharePoint timestamps the entries with the user who made the change. This is useful if you need to keep track for when changes occurred. All the details are under the "Multiple Lines of Text" Item here: support.microsoft.com/en-us/office/list-and-library-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7
I have a similar set up for my organisation, and I'm struggling with an additional step. Because only members from my organisation can fill in the form, Forms automatically knows the email adress from the respondent and it's added to the item on the list. However, this column isn't available in the dynamic content. I'd like respondents to get an email with a link to the item to add additional information (select a co-worker, in Forms that's not an available option). If I start a flow from the form, I can select the respondents' email adress, but not the item on the list. If I start a flow from the list, I can select a link to the created item, but not the respondens' email adress. Lists adds automatically a column with the respondents' email adress, but I can't find a way to use that information. Can you help me out?
I assume the "select a co-worker" implies that you're looking to use this as employee feedback or review situations. If I'm on the right track, then i would skip forms and power automate all together and just create a SharePoint/Microsoft list. Lists have a security setting called item level security. By default, with item level permissions, Owners Group/owners of the list can see all responses (HR and managers) but employees can only see their entries. www.sharepointdiary.com/2019/05/sharepoint-online-set-item-level-permission-in-list.html Hope that helps.
@@TDSheridanLab Thanks for the response. I'm afraid it's a rather complicated questionnaire in Forms, where we register incidents with agression or inappropriate sexual behavior of the children who stay in our accommodation (we take care of very troubled kids). The 'select a co-worker' is to select a buddy the colleague who was a victim of the agression or witnessed the situation would like to talk with to process the incident. My co-workers are not at all skilled with computers. Therefor I made a Forms questionnaire and after that they get an email with the link to the item, where all they have to do is fill in the name of a co-worker to talk with. I have a whole range of other automatisations to inform the staff, handyman, ... so everybody knows what to do. I made that based on your explanation in your video. Is there a way to keep this structure, but with the mail to select a buddy directly to the co-worker who registered the incident instead of me? Thanks for thinking with me on this, I really appreciate it.
I just figured it out accidentally. I changed the name of the column in the list to Email (it was Responder before) and then magically the Responders' email appears in the dynamic content.