Power Automate - Insert MS Forms Responses to Excel Table in SharePoint!
HTML-код
- Опубликовано: 15 янв 2023
- Create a Power Automate flow to collect MS Forms responses and insert them into an Excel table saved in SharePoint.
More Power Automate videos here: • Power Automate
Intro to Power Automate Cloud Flow series: • Intro to Power Automat...
Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden
My website: www.jeremybarden.com/
#powerautomate #rpa #forms #excel
Check out the next video which builds off of this flow! ruclips.net/video/UzRe2T0ii8o/видео.html
Thank you, this video was massively helpful. I was stranded for 2 hours at work
Useful video. I am struggling at one point to download everytime I had new responses. Now with Power Automate, things make very easier.
Great video! Thanks so much for your help!
Thks a lot!
Hello. Please it is posible to direct Microsoft reponses from differents forms directly in an excel excel
Hi! Thanks for posting. Yes, that is possible, you just need to have the right headers in your excel table to accomodate all of the various fields from your forms.
hii! thanks for the great video! wanted to ask is there any way to generate template based on user choice
1. user fill up a microsoft form to select which template they want
2. there is a sharepoint that will locate over 1000 of word templates
3. based on user choice, the word template will be populated with their information
And the placeholder for all templates is the same
i am facing trouble to handle the dynamicfileschema, it would be great if you can do a vid on this topic! thanks a lot
Hi! Thanks for posting. I can somewhat visualize that flow. I'm working through some other projects atm, but if you can get something started and shared in the PA community we can probably get you the rest of the way. All the best!
Hello! I followed these steps and I was able to create the flow. Nonetheless, the new row I´m getting is not going to the last row but to a random one. Do you know how to fix this?
Hi Carla, thanks for reaching out. Can you post on Power Automate Community with screenshots of your issue and tag @jibbs ? I will take a look over there!
I have everything set up the same way. The flow runs successfully, but the excel sheet never gets updated :( any idea??
thanks for posting. If you can post with more details in Power Automate Community and tag @jibbs, I can take a look over there.
Hello. I just found your video. Really hoping you can help me. I failed on the first step to link the Form ID. First issue, I am the creator of the form, but for some reason, the system did not detect the form in the list of forms. Secondly, I tried to copy & paste the Form ID (the code after '=' in address bar) into the action box, but the system return with 'Invalid connection, please update your connection to load complete details' notice.
Hi, thanks for posting. Were you able to find a solution? If you can post over in the PA Community with screenshots, I think we can resolve your issue.
Hello. And what about when response is editted?
Hi, this will only add the responses to the table once submitted. If someone wanted to edit their response, they would have to submit the form again.
Yes, i did all of that but the excel sheet is not updating with the new data.
Hi, can you post a screenshot of your flow, and any additional details as well, in the Community and tag Jibbs?
Found the issue to be the filter on the excel sheet.