Power Automate - How to get all Forms responses into Excel file and send it over Email
HTML-код
- Опубликовано: 27 май 2024
- #msformtoexcel #getallformresponses #PowerAutomate
Power Automate get all forms responses into your Excel and send that excel file to your email this video will cover this in detial. by default we don't have this trigger in Power Automate to get all responses so we have used MS Form Api to get that, I hope you will enjoy this video.
thanks so much for this! i struggled over a full weekend for the best way to do this, and you video saved me another few days of testing. thanks!
Great video! For anyone who’s getting the file format or file extension is not valid error. I had a similar issue and in my case the problem was under “Send an HTTP request to sharepoint” - the “maxResponseid” number should not be too large. For me, “maxResponseid=5000” is the limit. I simply removed the min and max response ids from uri. Hope this helps.
Edit: for those asking on 2:01, it’s a developer tool, how you access it varies by the browser you use. I could open mine by pressing f12.
Absolutely brilliant video sir! Thank you so much!!
PERFECT - the HTTP request was exactly what I needed, thank you sir!
glad it helped you
Thank you, thank you. I followed your instructions and they were great. However, the file attached would send over corrupted. After much research and trying different recommendations, I found one person state that it is a bug in the new version of power apps. I switched over to the older version and it solved the problem. Hopefully this saves someone else a few hours!
That‘s brilliant! I was searching for this since 2 hours, now i finally know how it works. thank you🤩
Glad it worked
Hello. Please it is posible to direct Microsoft reponses from differents forms directly in an excel excel
need to change colour on excel file after send email?
Please suggest the flow change or were to apply filter if I want the form responses received on today’s date only in an excel attachment and not all responses.
Good morning, how can I open the network head? Thanks
Great video I almost did it, but I have a question on minute 2:01 you open an inspector to get the url. How do I get there? Whatever you did was off screen. Thanks
Hello, can you do similar flow for a quizz ? Thank you again for your videos
Use same flow for quiz as well...but i will try in next video
Everything is happening except file error. File format or File extension is not valid
how to get time 2:01 you open an inspector to get the url. am not able to find . Please help...thank you in advance
The flow is working when I manually trigger it. What do I need to do to get it to automatically send the excel file email when a new response is submitted (new row added to excel)? Thanks for your help.
for that please use when a form response is submitted, there is seperate video in channel already for that
how to apply to ms list not to email?
with attachment in side
Hi, I keep on getting the error "This workbook couldn't be opened because the file format may not be matching with the file extension" and i used the extension .xlsx
try to recreate from scratch
@@LernenTech tried but nothing happened
Alos, how do I get it to overwrite the file and not create a new one each time? I just triggered another manual flow and it says the file already exists..." A file with the name Shared Documents/Forms/Document/new Member Survey.xlsx already exists..."
turn off Allow chunking in setting it should solve your problem
Hi Prakash, great video, I've been struggling on how to do this!
I want to do a slight variation of what you showed in your video: namely, create an Excel file for each new submitted response.
I would like each user who submits a response to receive his response via an email in an Excel format (so only their response, not other people's responses as well). What would be the easiest way to approach this?
Hello, can you do similar flow for a quizz ? Thank you again for your videos
It should be the same flow if the quiz is using forms. Just different responses in the form
@jeanlouis @@vono360 is right