How to Manage Optional MS Forms File Upload in Power Automate

Microsoft Forms can always come in handy for data collection across the organization. From simple forms, e.g. Employee Net Promoter Score (eNPS), Training Registration Forms, up to complex Forms with branching, customizations, and file uploads.
Another beauty is the native integration between Microsoft Forms and Power Automate. Citizen developers with little to no experience in Power Apps can use for as their viable alternative for Front End Designs, Power Automate for Middleware, and Sharepoint List for Backend (database).
Whenever you create an MS Form that requires the users to upload a file or two, you will need to write a simple JSON schema to add the uploaded file to the SharePoint list.
In this video, I show you how to do this and, more importantly, how to handle the error often returned when one of the upload fields is made optional.
Link to copy the JSON Schema: gist.github.com/theoyinbooke/...
How to Retrieve Employee details in Power Automate: • How to Retrieve Employ...
#powerautomate #microsoftforms #sharepointlist #fileupload

[@theresabrenholt9367]

Great job, thank you for posting this.

[@sy_elephant]

Thank you so much sir!

[@saicharanjanakiraman5243]

Excellent , Thanks for posting this . looking forward to see more.

[@KeshanNaidoo]

thank you for this!! after reading many blogs and watching many videos ?!! this really helped me,. Thank you !!!!

[@kamilapereiradejesus7772]

Thank you so much this video helps me a lot

[@mbondka]

Wonderful, thanks for sharing! :-)

[@kamilapereiradejesus7772]

This video really helped me!! thanks

[@TheOyinbooke]

Glad it did. Thank you @Kamila Pereira

[@EpicDreamer_]

Thank you! You helped me a lot with this trick. I'm a new subscriber! Greetings!!!

[@TheOyinbooke]

Hi Ana, thank you for subscribing and glad that you found the video useful

[@kanwalsingh2802]

Hi, thank you for the video, I am getting this error message. Any help would be greatly appreciated "Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'."

[@marekmierzynski5834]

I have a survey with more than 30 multi-file, not mandatory upload questions. I want to use power automate to build Excel with links to these attachments (using friendly name). I would love to call a child flow (that would do the parsing, and retrieving a link) in place where I assign response to Excel column. However that is not possible. Is there better way to handle that case ? All internet solutions says about one or two upload questions. But what if I have so Many?

[@earl6853]

Does this allow external users to upload as well?

[@abuena73]

Are 2 attachments can be hold by 2 separate SharePoint fields, like attachment 1 will be patched to Question# 1 column, while attachment 2 will be patched to Question# 2 column?

[@TheOyinbooke]

Hi @Arish,
Records are arranged row-wise in SharePoint. you can add attachment to an item or to a particular column. The second option is what you are inquiring about.
It is possible. However, I may need to create a video tutorial on this as I don't have one at the moment

[@abuena73]

@@TheOyinbooke thank you! 🙏

[@ebrimacamara2094]

Hii....! cant find the github file

[@TheOyinbooke]

changes made to the link. you can click on it again now. thanks