MS Form Data to SharePoint with multiple attachments using PowerAutomate

Video explains about capturing MS Form data and save it in SharePoint along with multiple attachments using PowerAutomate.
Sales report has been used demonstrate the concept.
Video also explains about generating schema from sample Json.

[@m365techhelp]

Dear folks , Below is the updated video to handle if file is not attached - kzbin.info/www/bejne/pXnGnJePmr59f7c

[@kpopante]

super helpful and straightforward!

[@dhruvdido]

Bro have been seeing same tutorial by other KZbinrs Did not work out. This was my final shot when i opened your video. It worked flawlessly.

[@m365techhelp]

Glad it helped you!

[@Prasadshelar9898]

Thank you so much bro. I was searching on KZbin for this from last 1 week for multiple attach. Finally ur video got..

[@m365techhelp]

Welcome 👍

[@Chumpchanger]

Was able to follow along and get attachments working in my Form > SharePoint list. Thanks!

[@m365techhelp]

Glad , it helped you !

[@ScottishPoliceFederation]

First class instruction Thankyou

[@m365techhelp]

thanks!

[@carolinemansfield2472]

Fantastic! Works as instructed.

[@odaily]

Thank You for your tutorial, I also added email notification function too.

[@m365techhelp]

Awesome, thank you!

[@JatinDas007]

Excellent! Thank you so much!

[@nyambesimangolwa5755]

Thank you so very much for this. You have helped me greatly.

[@m365techhelp]

You are so welcome!

[@jdtoronto001001]

Thank you so much, this worked perfectly!

[@marcsaturnino1041]

Great demo. Thank you.

[@m365techhelp]

Thanks for watching!

[@gokhansarpkaya]

Superb job! This definitely made my life easier!!

[@m365techhelp]

Great to hear!

[@maximusclaudius2008]

Brilliant stuff. Loved it.

[@m365techhelp]

Glad to hear it!

[@ferneyol]

perfect ..thanks

[@m365techhelp]

Welcome 😊

[@LernenTech]

Nice content :)

[@derekfleming1747]

File upload is NOT available when sharing the form externally

[@Wazzanx]

Thank you so much

[@tockjutube]

Thankx for the excelent simple clear video. in my case flows run successfully but no attchement can be found on the list.I have no idea what is wrong due to no error.

[@andrearodze]

¡Muchas gracias! Me ha servido un montón para mi proyecto

[@simondrayton7614]

Hi Great video thanks, what is the option of the attachment fields is blank i am getting null error when no attachment

[@m365techhelp]

Before parse action , you would need to check whether form response field "Upload Sales report" is blank/null or not. For that, you may use a compose action with input "Upload Sales report" and then in Condition action check if Output of compose is not equal to blank.

[@nithyasukumar]

This is perfect. it works when we upload the attachments. What if we upload one attachment and not the other? I get an error.

[@caophilippe]

Thanks for the tuto! It works really well for Forms that I submit. But the attachment is not added for Forms that are submitted by other users. Can you help?

[@manishadoncouse4666]

Hi, excellent video. Very straight forward and easy to follow for newbies. I using this for group form and getting file not found error. Any idea? thanks in advance.

[@thecynthia2710]

Hello! Is there a way that instead of being attached to the sharepoint list, it will be automatically saved to a newly created folder in the sharepoint library?

[@fangas]

Hello. This is very useful, but If I wanted to save those attachments into a Doc library? How Can I do it? Thanks

[@aldinhasanovic2680]

I am getting Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'.

[@juanmanuelenriquez3635]

Hi Amazing!. One question. Do you have a similar one for SharePoint Library?, Thank you in advance.

[@syamsv1096]

Hi mate, it really worked, may i ask a solution for displaying a clickable link of multiple attachement to a pdf similarly. thanks

[@theresatiurma3836]

My flow works fine, but I got duplicate entries on the List , one without attachment and another one with attachment? Can you help me to figure out why? How to delete one of the entries (the one without attachment) ?

[@marinaaparicio3985]

Hi do you know if it creates a problem if you go on one drive and delete older files you used for testing? It seems the form keeps a count of every item also, so far the count on my form is 30 but when I start using it live I would like it to start from zero.

[@rajaabllahtengkusyazwani465]

The video is very useful. Thank you but my flow failed if one of attachement is not uploaded. I use expression output = null but its not working. Can please help me on this

[@jorgeocampo3113]

What if forms pro is being used do you have a video for that?

[@evertonmedeiros7223]

My flow fails when there is no attachments. How to fix it?

[@m365techhelp]

Hi Everton Before parse action , you would need to check whether form response field "Upload Sales report" is blank/null or not. For that, you may use a compose action with input "Upload Sales report" and then in Condition action check if Output of compose is not equal to blank. Drop me your email id or write me at [e-mail] , I will share the screenshot for the condition to help you better.

[@Manndekhinepali]

@@m365techhelp Thanks. It worked for me. Great

[@meryla.l.8245]

@@m365techhelp Can you explain this further?

[@rajeshmeruguU36]

Hi Thank you! Flow fails incase there is no attachment? In my case its not mandatory to attach a file. Please can you advise how to handle when there is no attachment in the same flow?

[@m365techhelp]

Hi Rajesh, you can use Compose action to check the length of attachment before attaching it. For example: length(body('Get_response_details')?['Upload Sales Report'])

[@rajeshmeruguU36]

@@m365techhelp Thank you!!

[@evertonmedeiros7223]

@@m365techhelp Hello! very good video, I followed as it is and worked. Question, How do I set up in this case when I don't upload a file. ?

[@nawal7721]

can you send those attachment in a message to teams chat?

[@israelcastillo7329]

Is there a way so that each attachment will be updated as a separate line in sharepoint?

[@mdarifabdullah]

Create 2 different flows

[@miriamfitch4277]

Why am I getting the form fill twice?