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 - ruclips.net/video/oHckdYeYJIU/видео.html

[@dhruvdido]

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

[@m365techhelp]

Glad it helped you!

[@kpopante]

super helpful and straightforward!

[@Prasadshelar9898]

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

[@m365techhelp]

Welcome 👍

[@carolinemansfield2472]

Fantastic! Works as instructed.

[@jdtoronto001001]

Thank you so much, this worked perfectly!

[@Chumpchanger]

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

[@m365techhelp]

Glad , it helped you !

[@JatinDas007]

Excellent! Thank you so much!

[@andrearodze]

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

[@gokhansarpkaya]

Superb job! This definitely made my life easier!!

[@m365techhelp]

Great to hear!

[@nyambesimangolwa5755]

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

[@m365techhelp]

You are so welcome!

[@maximusclaudius2008]

Brilliant stuff. Loved it.

[@m365techhelp]

Glad to hear it!

[@marcsaturnino1041]

Great demo. Thank you.

[@m365techhelp]

Thanks for watching!

[@ScottishPoliceFederation]

First class instruction Thankyou

[@m365techhelp]

thanks!

[@LernenTech]

Nice content :)

[@odaily]

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

[@m365techhelp]

Awesome, thank you!

[@Wazzanx]

Thank you so much

[@ferneyol]

perfect ..thanks

[@m365techhelp]

Welcome 😊

[@derekfleming1747]

File upload is NOT available when sharing the form externally

[@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.

[@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.

[@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.

[@juanmanuelenriquez3635]

Hi Amazing!. One question. Do you have a similar one for SharePoint Library?, Thank you 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?

[@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?

[@syamsv1096]

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

[@fangas]

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

[@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.

[@jorgeocampo3113]

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

[@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 ''.'.

[@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

[@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.

[@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) ?

[@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. ?

[@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?

[@nawal7721]

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

[@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?