I've created a Microsoft Forms with some upload questions. The answers should be accessible for other colleagues within the organization. The default setting, which is not adjustable, will store the data on my personal OneDrive.
I want to create a flow that stores the answers and attachments, in OneDrive in a folder that is generally available by the organization instead of my personal folder. It should create a folder per respondent included the answers/attachments.
Solved! Go to Solution.
SharePoint is probably a better solution as you mentioned earlier.
How much differs the current flow(OneDrive) from a SharePoint perspective.
Still busy with the flow and still doesn't work the way how it supposed to be.
Maybe their is a much more easier solution, hopefully you can help.
Just saving all the attachments in the notification mail after the form is submitted. The answers can be found in the regular excel file. So it is just to saving the attachments in the mail. I've got 2 questions (1 mandatory 1 optional) with the possibility to upload a file.
Could anyone help
This is amazing and significantly helped. I have followed this however it creates the folder as requested and dumps the attachments in it with the text file, however it also puts the attachments outside the folder loose. Any ideas. The only other addition I have made is that it creates a Trello card, the card gets created and then gets renamed in Trello to include the unique card number, there is a delay and then I get card ID. I then rename the folder in OneDrive to the new Card name.
@Jcook Thank you, I have found this post really useful. I have managed to create a flow from an MS Form that includes four upload questions, which assigns all of the attachments from these questions into a single file for that form response. I am running into two problems that I would really value some help with though.
The first is that although the attachments are appearing correctly in a single folder, they are also appearing in the question 1, 2, 3, and 4 folders that were originally automatically created in Sharepoint. I do not seem to be able to delete the folders and I cannot see how to stop the files from being duplicated. Any ideas?
The second issue is that the users of the form may not need to use some of the upload questions. For example, one of them is an opportunity to upload logos if required. When trilling the workflow, if I do not upload a document for any of these questions I receive a 400 error at the parse JSON stage because it cannot find the attachment. Is there an additional step that I need to include, such as a condition of some sort, above the parse JSON to prevent it from failing at this stage when the user doesn't upload content for one or more questions? Currently when I run a test such as this the other attachments do appear in a folder like I want them to, but the workflow does not go any further than the JSON stage, which stops the entry appearing in my Team list or reaching approval stage.
Thanks in advance
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.