Save Microsoft Forms Attachments to SharePoint with Power Automate

  Рет қаралды 121,638

April Dunnam

April Dunnam

Күн бұрын

Пікірлер: 326
@AprilDunnam
@AprilDunnam 3 жыл бұрын
Important Note: The demo I show is of a Personal Form in Microsoft Forms, which is why the data is stored in OneDrive for Business. We also have the ability to create Group Forms in Microsoft Forms. This means, instead of the form and attachments being tied to the person who created it, it is associate with a Group and the attachments then are stored in the SharePoint Document library of the group. So if that's how you create your form you might not need this process. If you need to move the attachment to a different SharePoint library the only change is to use the "Get File" SharePoint Action instead of the "Get File" OneDrive action. Everything else is the same.
@cvkealey
@cvkealey 3 жыл бұрын
Actually, the "Get File" SharePoint action doesn't work to move those files attached to Group Forms because the "id" of the file that's provided in the JSON from the response details isn't the same as the "id" needed by the Get File action. You actually need to use the OneDrive actions to "Get file metadata" of the attachment, feeding it the "driveId" and "id" (concatenating them with a . in between) from the JSON, then user the Id output of that action with the OneDrive "Get file content" and THEN the SharePoint "Create file" action. It's a pain, but does work.
@vlakdrak4774
@vlakdrak4774 3 жыл бұрын
Thanks so much. Worked for me, however how do I get the 'attachments' field to show first in the columns of the list? Many thanks.
@vanessayamat4873
@vanessayamat4873 3 жыл бұрын
@@cvkealey thank you!!
@cvkealey
@cvkealey 3 жыл бұрын
@@vlakdrak4774 see support.microsoft.com/en-us/office/change-the-column-order-in-a-list-or-library-6f14f5a4-1df4-48a8-a57b-dc1b8f8d03d2
@heatherfeather2621
@heatherfeather2621 3 жыл бұрын
Please do a video on this - lost me
@cmacdhon
@cmacdhon 3 жыл бұрын
Holy crap!!! This is exactly what I have been trying to accomplish for weeks!! I was even told by a so-called 'expert' that due to limitations in Power Automate, it was not possible to retrieve file names of attachments if there was more than one. I have spent all day trying to come up with a believable sob story as to why I could not fulfill this requirement, but thanks to you, I can save the day, and make myself appear 100 times more capable than I really am. I'm going to take full credit for figuring it out myself, but I'll always know that it was all you! 😉Thank you! thank you! thank you! This was HUGE for me.😃
@AprilDunnam
@AprilDunnam 3 жыл бұрын
Well I'm glad that I could help!! 😀
@garycarmen9212
@garycarmen9212 2 жыл бұрын
Thank you April. This video was fantastic. I did try to replace the expressions with the name for the Parse Json as you described for uploading more than one file, although I had an issue whereby the attachments would not open. I realised that I had an 'apply to each' for both the get file content and add attachment. It is worth noting in case others have this issue, the get file content and add attachment needs to be wrapped in the same apply to each.
@crystalmarini5208
@crystalmarini5208 Жыл бұрын
This is more complicated than it looks and I still can't get it to work. April, it would be a great video to walk us through the whole thing with multiple attachments. It's not obvious for non-developers...
@israelalvesferreira9631
@israelalvesferreira9631 2 жыл бұрын
I had a workflow before, much more complex with a Array function, i made it again following this tutorial, worked perfectly, congrats for the video, clear, straight to the point!!!!
@lilykong1989
@lilykong1989 10 ай бұрын
THANK YOU SOOOOO MUCH April! This helps me a lotttt!! I have tried so many ways from other bloggers and youdubers and all failed because they are not as detailed! I love all the content you have posted! YOU ARE THE BEST!! THANK YOU SO MUCH!!
@clifsportland
@clifsportland 3 жыл бұрын
I'd happily pay you hundreds of dollars for the information you just shared! Thanks!
@AprilDunnam
@AprilDunnam 3 жыл бұрын
Thank you I appreciate that!
@clifsportland
@clifsportland 3 жыл бұрын
@@AprilDunnam do you have a link to the video you referenced at the beginning? Moving forms data to a list?
@laurentvandescuren2082
@laurentvandescuren2082 3 жыл бұрын
Thank you, you saved me from a nervous breakdown. Finally a clear flow to save Forms attachments.
@AprilDunnam
@AprilDunnam 3 жыл бұрын
Glad I could help!
@bobbirowlett6728
@bobbirowlett6728 Жыл бұрын
This is so amazing. I love how clear an step-by-step you have provided this information. I have been struggling and you have my perfect answer. I can't thank you enough!!
@AprilDunnam
@AprilDunnam Жыл бұрын
I'm glad that I could help!
@vipindhir1810
@vipindhir1810 2 ай бұрын
Very helpful - like how you explained each step with Json - and using first and name if multiple file attachments.
@Jziegenhirt
@Jziegenhirt 3 жыл бұрын
April, your videos make me constantly want to learn more! Thank you for these videos.
@AprilDunnam
@AprilDunnam 3 жыл бұрын
I'm so glad to hear that! You're very welcome 🙂
@renanmoreira2028
@renanmoreira2028 3 ай бұрын
After 3 years, you helped me alot, thanks !
@AprilDunnam
@AprilDunnam 3 ай бұрын
Glad I could help!
@pupycron4302
@pupycron4302 Жыл бұрын
This has been SO helpful. I thought this will be easy I can just figure it out myself, and boy was I WRONG!
@MarieAndrae
@MarieAndrae 3 жыл бұрын
So glad I found your video - I've been playing around with this for weeks and after following your steps I got it working in under 5 minutes!
@AprilDunnam
@AprilDunnam 3 жыл бұрын
Fantastic! Glad this was helpful!
@lawrencesanders4134
@lawrencesanders4134 3 жыл бұрын
April, this video was very clear and scoped perfectly. Great job!
@AprilDunnam
@AprilDunnam 3 жыл бұрын
Thanks Lawrence!
@Coco-dh1by
@Coco-dh1by 2 жыл бұрын
Hi April. Wow! I followed your steps and it actually worked first time - I am super impressed and thank you so much!
@AprilDunnam
@AprilDunnam 2 жыл бұрын
Yay! Love when it works the first time :)
@surfingjemima
@surfingjemima 3 жыл бұрын
This is brilliant!! Thank you! I have been trying for days to find a video showing how to do this that actually works!
@AprilDunnam
@AprilDunnam 3 жыл бұрын
You're very welcome, glad it helped!
@gmc111568
@gmc111568 9 ай бұрын
This was extremely helpful and just what I was looking for. Thanks for your clear explanation and detail. This actually helped me learn a couple of other things as well that I’d been wondering about!
@AprilDunnam
@AprilDunnam 9 ай бұрын
I'm so happy to hear that. Glad I could help!
@stefanietam8481
@stefanietam8481 Жыл бұрын
Your videos are the best! So well explained and thorough. You save me so much headache. THANK YOU, THANK YOU, THANK YOU!
@PhilipAAlia
@PhilipAAlia Күн бұрын
Thank you for your video, April. It is well done, very helpful and your expertise is apparent. I am trying to create a master folder in Sharepoint with a tracking document for a training program to drop certificates of completed programs in to. This is for a volunteer organization I am a part of. My challenge is that there are multiple questions each with a required certificate.
@cbeyonduk
@cbeyonduk 3 жыл бұрын
Hi April, thanks for this very informative video. I have a form which has TWO fields for adding attachments (the first is to add an XLS expense claim form, the second is to add the receipts saved as a PDF doc). I've followed your video but created two separate flows (Parse JSON, Get file contents using path and Add attachment). For both i've used the "first(body('Parse_JSON'))?['name'] expression" as each of these two fields only allows the uploading of 1 attachment each. The files are correctly saved in their respective folders on OneDrive (Question and Question 2). Question's file format is XXXX.XLS (e.g. Expenses_BOB.xls), Question 2 file format is XXXX.PDF (e.g. Receipts_BOB.pdf) The problem i am having is the second one is failing (at Get file contents using path). The raw input is: "host": { "connectionReferenceName": "shared_onedriveforbusiness", "operationId": "GetFileContentByPath" }, "parameters": { "path": "/Apps/Microsoft Forms/Expense Claim Form/Question 2/Expenses_BOB.xls", "inferContentType": true It is failing with a 404 Status, The resource could not be found. Looking at the path in the second "Get file contents using path" it is referencing the file from the first "Get file contents using path" (Expenses_BOB.xls instead of Receipts_BOB.pdf) How do I address that? Many thanks in advance, Graeme
@MaunghiPearson
@MaunghiPearson 11 ай бұрын
Awesome video, April! Love your channel.
@AprilDunnam
@AprilDunnam 11 ай бұрын
Thank you so much!
@user-zj3pm9dy7f
@user-zj3pm9dy7f 3 жыл бұрын
April, amazing video. Thank you so much! One thing I figured out - and I know this was at the very end when you were trying to finish up so there was not a lot of time spent on it: You show two "Apply to each" boxes when grabbing multiple files, but I could only get it to work when I had ONE "Apply to each" action with both the "Get file Content using path" & the "Add attachment" in the same "Apply to each" action 'box.' Thanks again!!
@stevel4734
@stevel4734 3 жыл бұрын
I was having same issue. Thanks for posting as this was driving me crazy! Works now once I put them in the same Apply to each action.
@paigesmith9771
@paigesmith9771 Жыл бұрын
This worked! Thank you
@kyosho3218
@kyosho3218 3 жыл бұрын
Thankyou for the vid - I have been struggling parsing the JSON until I saw this. Awesome.
@AprilDunnam
@AprilDunnam 3 жыл бұрын
You're welcome!
@eaklause
@eaklause 9 ай бұрын
I can't tell you how often I come back to this great video for instruction. Thank you SO much April. Any chance of you making a video if there are TWO attachments within the same form that you need in the same SharePoint list?
@guluu6993
@guluu6993 3 жыл бұрын
April, Thank you for the how-to. I follow your guide as exactly as I can tell however, I am running into a problem. When there is no attachment the flow fails.
@morganmcgary921
@morganmcgary921 2 жыл бұрын
Another fantastic video April!
@AprilDunnam
@AprilDunnam 2 жыл бұрын
Thanks so much!
@shivabkumar7999
@shivabkumar7999 9 ай бұрын
Awesome work and very useful video, April. Keep it going ! 👌
@AprilDunnam
@AprilDunnam 9 ай бұрын
Thank you so much!
@bikerz1k
@bikerz1k 7 ай бұрын
Great tutorial! It's so good, it was recommended in the power community as a solution! Thanks.
@AprilDunnam
@AprilDunnam 7 ай бұрын
Oh wow, that's awesome!
@AMindGame
@AMindGame 2 жыл бұрын
You're our Queen. Thank you so much for your time and simple instructions.
@anniebhutto6012
@anniebhutto6012 9 ай бұрын
I love you
@AprilDunnam
@AprilDunnam 9 ай бұрын
Thank you so much ♥
@johnrybitski2555
@johnrybitski2555 Жыл бұрын
Thanks April as this worked great if the form has an attachment. However, my flow failed when I submitted a response without one. Is there a way to avoid this?
@colleenhughes7846
@colleenhughes7846 7 ай бұрын
Did you identify a solution?
@TheBlickcat
@TheBlickcat 9 ай бұрын
YES! THANK YOU! Been looking all morning for this solution. Much appreciated
@AprilDunnam
@AprilDunnam 9 ай бұрын
Glad to help!!
@davidferrick
@davidferrick 3 жыл бұрын
Thank God for pause because you sprinted through this process. :)
@AprilDunnam
@AprilDunnam 3 жыл бұрын
Fun fact: You can also adjust the playback speed of a video by clicking the settings gear in the video. Maybe you can try that next time if the FREE content you're watching isn't at your preferred pace. Could prevent you from having to leave passive aggressive comments on other videos :)
@diaharrill4810
@diaharrill4810 3 жыл бұрын
I have my flow set up just like your vid, but get an error 'Get file content using path' failed - The resource could not be found. The attachment is in the proper SharePoint folder. On the inputs of Get file content using path action, the file path = /Apps/Microsoft Forms/file name test.docx What am I missing? Any hints would be gladly taken!
@TanyB
@TanyB 4 ай бұрын
April I need help, I used This flow and everything is fine but when I add Multiple photos in the form, it goes to the share point but when I try to open from The share point attachment area the image won’t display after it opens. But if I only upload one image it opens fine.
@eliezermedina2824
@eliezermedina2824 2 ай бұрын
Hey, I have this same issue. Flow works perfect for just one attachment but for more than one attachment is a problem. If you found a solution to this, please let me know.
@vanessaaustin3348
@vanessaaustin3348 Жыл бұрын
Hi April!!! Thank you so much for this video. I was finally able to get it to work and am DELIGHTED!
@AprilDunnam
@AprilDunnam Жыл бұрын
I'm so glad it worked!
@vanessaaustin3348
@vanessaaustin3348 Жыл бұрын
@@AprilDunnam my flow is being funky. Uploading a file is not mandatory and there will be instances where a file will not be present. Do I have to do a yes/no condition?
@Jojje67
@Jojje67 3 жыл бұрын
Great video and good explanation about JSON. But an easier way to grab the file is instead of using "Get file content using path" is to use "Get file content" and use "id" from Parse JSON. And you already have the "name" in Parse JSON. No need for an expression when you Add attachement.
@morganmcgary921
@morganmcgary921 2 жыл бұрын
Joakim, thanks sooooo much for posting this. In my environment I could NOT get the get file content using path method to work but your proposed change fixed it right up for me and it's working now. you rock!
@AliOGUL
@AliOGUL 2 жыл бұрын
for anyone who has issue finding "file content" , this is the best approach. when using "Get file content" , don't put the path (you will have issues otherwise), just use JSON id alone; first(body('Parse_JSON'))?['id'] and then when adding attachment , as Joakim mentioned, you just need to add "name" as it will be available in the dynamic content list under "Parse JSON"
@TaraCotz
@TaraCotz 2 жыл бұрын
What parameters do you have to have in the List in order for Excel files to be extracted from a form? I am really struggling to make this work. I will try your tip and check if it would work.
@CP-vt9wr
@CP-vt9wr 2 жыл бұрын
Thank you, April, this was very helpful! An easy and elegant way... 🙂
@AprilDunnam
@AprilDunnam 2 жыл бұрын
Glad it was helpful!
@ThePauldo
@ThePauldo 2 жыл бұрын
Great instruction, really nice and clear. However I think I followed it to a T but it returned an error: Action 'Parse_JSON' failed, with error details stating: The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Unexpected character encountered while parsing value:
@anthonnyvazquez5516
@anthonnyvazquez5516 Жыл бұрын
hi, I have the same issue
@laurenmeier4746
@laurenmeier4746 3 жыл бұрын
Another great Video April! Thanks so much for helping me automate my business
@AprilDunnam
@AprilDunnam 3 жыл бұрын
You are so welcome Lauren!
@bigfoot99uk
@bigfoot99uk 3 жыл бұрын
Thanks so much for this! I think i would have spent ages trying to figure this out.
@AprilDunnam
@AprilDunnam 3 жыл бұрын
You're very welcome!
@SharonKopf-qj8wg
@SharonKopf-qj8wg 2 ай бұрын
sadly this hasn't worked for me, i'm unsure if its a restriction by my company or something i'm doing wrong, i followed your video entirely but it keeps failing at the get file path using onedrive content i get the following error on the output log { "status": 404, "message": "The resource could not be found.", "source": "api.connectorp.svc.ms" } am lost as to how to get this sorted. :(
@nadiadamiens3222
@nadiadamiens3222 7 ай бұрын
Thank you April for this very helpful video I wonder how you managed to display the document in columns in micsosoft list?
@florian1054
@florian1054 2 жыл бұрын
Thank you a lot April, this was very very helpful !!!
@AprilDunnam
@AprilDunnam 2 жыл бұрын
Glad it was helpful!
@RobAlti
@RobAlti Жыл бұрын
@April: Hi, my Flow run failed (on the Step: Parse JSON) !!! Error Details: 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 ''.'. Any Ideas why i got this massage?
@Yeoolw
@Yeoolw 8 ай бұрын
This is exactly what I am looking for. Thank you! 😊
@AprilDunnam
@AprilDunnam 8 ай бұрын
You’re welcome 😊
@Snakemailo
@Snakemailo 7 ай бұрын
Dear April you know, this is a lake of desert for me !!!! Thanks greatly !!
@AprilDunnam
@AprilDunnam 7 ай бұрын
You're welcome 😊
@nagiosmsff-rsp332
@nagiosmsff-rsp332 5 ай бұрын
Thank you for this informative video ! I only have a question regarding the SharePoint list column of the attachment and what type is it ?
@gabatsoswekentse4699
@gabatsoswekentse4699 2 жыл бұрын
Thank you so much April, exactly what I needed
@AprilDunnam
@AprilDunnam 2 жыл бұрын
You are so welcome!
@jordancartmell4920
@jordancartmell4920 Жыл бұрын
Great explanation, you've saved me many hours! Thank you
@AprilDunnam
@AprilDunnam Жыл бұрын
Yay! So happy to hear that 🙂
@timoneill1477
@timoneill1477 2 жыл бұрын
This is great thanks, helped me further streamline our processes and reduce email traffic in our business.
@AprilDunnam
@AprilDunnam 2 жыл бұрын
Glad it helped!
@thelmanyanway4590
@thelmanyanway4590 7 ай бұрын
Hi April, thank you so much for this video. Question- how did you create the expression to include the parse json? I keep getting an error message that.
@abuena73
@abuena73 3 жыл бұрын
What if Forms were designed to collect uploaded files for each questions, let say 10 questions?
@Tanveerahmed-hl7ek
@Tanveerahmed-hl7ek Жыл бұрын
Hi April, I setup the flow and it worked fine, however after going live some users didn't attach any files on the form. Then flow failed to run for the requests which do have attachments. Could you please provide a solution to it. I have already searched for the solution on the flow community but am unable to get to the solution
@NieMaUsername
@NieMaUsername Жыл бұрын
Hi! I have the same issue (this is how I find this video - trying to find solution). This is good when attachment is required. Doesn't work if it's voluntary.
@husalkahli
@husalkahli 2 жыл бұрын
Thanks a lot, this was helpful and you covered everything, yes I tried this in a Group in SharePoint and it works fine.
@AprilDunnam
@AprilDunnam 2 жыл бұрын
Glad to hear!
@brandiwoodson7404
@brandiwoodson7404 3 жыл бұрын
So I did this to a T and it works however, it's doubling my list item entry. For every entry I'm getting two line items in my list and only one carries the value. I don't know what is going on.... So annoyed I can't figure this out on my own. I tried powerapps custom form but wouldn't work and now i'm stuck with forms for users to enter a entry into a list. Annoyed, love SharePoint etc but I'm used to MS ACCESS where things were simpler. :/
@brandiwoodson7404
@brandiwoodson7404 3 жыл бұрын
OMG! I'm so stupid, as I finished writing this, I realized I have two demo flows - one from another video trying to explain this and yours! I'm dumb! Disregard my frustration, I just deleted the other flow hahahaha. Little to no sleep here. What a dodo.
@AprilDunnam
@AprilDunnam 3 жыл бұрын
Haha - no joke I have did the exact same thing before 😂 Glad you got it sorted out!
@bobbirowlett6728
@bobbirowlett6728 Жыл бұрын
Is there a step that can be shared for how you would do automatic maintenance on the original location of the documents uploaded. In your example you're taking from the original one drive location and copying them to the list. Works so well! But we still have a lot of files that will just sit in the original location. Thinking it would be a good idea to keep that trimmed down since already found in the list.
@michaelgorbachepmanurung5491
@michaelgorbachepmanurung5491 4 күн бұрын
Hi April this is great. Can we create the attachment not in 'attachment' column, but in a custom column of sharepoint list? Lets say i have 'Employee ID Card' img column i create. I want the form submission attachment to be stored on that column.
@Coco-dh1by
@Coco-dh1by Жыл бұрын
Hi April, I use this video all the time for my Flows that have attachments - do you perhaps have an adjustment for when there is not attachment as sometimes we do no have a document required as evidence for the Flow. Warm regards
@shawnbadgeley4787
@shawnbadgeley4787 2 жыл бұрын
Thank you for this valuable training video. It was extremely helpful and easy to follow.
@AprilDunnam
@AprilDunnam 2 жыл бұрын
Great to hear it was helpful and easy to follow. Thanks!
@MrKnarf82077
@MrKnarf82077 2 жыл бұрын
I have everything working up to the "Get File Content" section where it grabs the file name. Even though the file exists, it keeps advising that the fild id is not valid. Any thoughts?
@anitawhittaker9308
@anitawhittaker9308 2 жыл бұрын
Hi April, thank you so much for this video it has been great to be able to get my attachments over to MS Lists. I now have an issue with the error below which appears when users do not add an attachment. Could you help. 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 ''.'.
@joycecha9483
@joycecha9483 Жыл бұрын
I'm having the same issue - some MS forms without attachments (not required). Tried adding in "anyOf" however this issues a 'Enter a valid json' error message. @April Dunnam - if you happen to have a solution for this it would be a great addition to a very instructive video. Anita - If you've happened to solve for this, would be grateful to get how you approached this.
@peterdixon7673
@peterdixon7673 Жыл бұрын
I have something similar to this but it breaks whenever someone puts a special character like comma or apostrophe in the file name of the uploaded file.
@PatRook-sy4jq
@PatRook-sy4jq 5 ай бұрын
Hi, this is super helpful. Quick question: My flow works great when I upload a file to my form, but it fails at the Parse JSON step if there was no file uploaded. Is there a way to edit the parse JSON step so that it skips if there is no form file upload? Thanks!
@SirCruxr
@SirCruxr 3 жыл бұрын
This was really helpful! I am having trouble trying to get the attachment to pop up using a group form and Sharepoint Library. Any ideas on what I should place in the file content area?
@DarkMaxxFR
@DarkMaxxFR 3 жыл бұрын
Hi April, Thank you for the video but I can't do it with a Sharepoint library. I have 2 possible choices: - Toggle the attachment - Add in my MS List the URL that leads to the document library. Can you help me to find a solution? I am completely blocked. Great video anyway. Thanks
@meaganmcolin9433
@meaganmcolin9433 2 ай бұрын
What if you want to retrieve files from both upload questions? Question and Question 1? I am particularly needing to save them to Sharepoint.
@vishalkarthik9971
@vishalkarthik9971 7 ай бұрын
The video was very helpfull to me. As you mentioned if the attachment is more than 1 we should not use first(body) expression, so what would be expression for 3 attachment or >3
@vbrittney
@vbrittney 3 жыл бұрын
Hi @april i kee gettng this error message " Correct to include a valid reference to 'Parse_JSON' for the input parameter(s) of action 'Get_file_content_using_path'." what do I do?
@jean-emmanuel5616
@jean-emmanuel5616 2 жыл бұрын
Hello April, Thank you for clearly explained the steps.I do have a form with attachment that i am looking to collect the data in List, but when i create the item and plugged the site address, the list name cannot be found.I uploaded the files to One drive and can see the file in the Team folder that i created.What do you suggest me to do in that case ? Thank you.
@lachlancalder9029
@lachlancalder9029 7 ай бұрын
Thank you so much! I never comment. This was incredibly helpful.
@AprilDunnam
@AprilDunnam 7 ай бұрын
You're welcome! Glad it helped!
@michelledesilva5012
@michelledesilva5012 7 ай бұрын
Thank you. I’m having issues in pasting the code in json expression. Is there a reason for it? It doesn’t let me paste the code. Just comes up an empty cell.
@bethr5048
@bethr5048 8 ай бұрын
This worked great... until recently. Any thoughts why suddenly it breaks when there is no attachment? :(
@Coco-dh1by
@Coco-dh1by Жыл бұрын
Hi April, I have been using this video for some really important Flows in our business but in the past few days I have received an error when trying to open the document in the Sharepoint List. I have followed your steps implicitly and it works if there is one document but when I try multiple documents I cannot open the document - any idea what could be wrong?
@garycarter222
@garycarter222 8 ай бұрын
This is really helpful, the only thing I have noticed is that when the image is saving into a folder it is then creating a new folder of the image name which is empty. What would be causing this?
@laurenblack9693
@laurenblack9693 5 ай бұрын
Hi April, this worked for attaching my first attachment. Although I followed the same exact steps again for my 2nd attachment and am getting the error that the file does not exist. Is it a different expression to be used for the 2nd attachment?
@jiniy
@jiniy Ай бұрын
Hi April, this was an incredibly informative video. One issue that that I am facing is that I cannot open the documents in both the library and list. I’m unsure what the issue is but locally I can open the documents but not through share point. Do you know how to fix this?
@KrisztinaTatai-Szűcs
@KrisztinaTatai-Szűcs Жыл бұрын
Hello April, I would like to ask for your help because I have a form where attachment is not a mandatory field. How should I change the process in order to save the other data to my list? Thanks in advance
@jplewis1452
@jplewis1452 2 жыл бұрын
my file path has brackets in it example the form name is Report an issue (2). How do I write this in the "Get file content" as it fails due to "()"
@Vikhingr
@Vikhingr 7 ай бұрын
If I have multiple questions for uploading attachments, what should the flow be like?
@srinik-td2wy
@srinik-td2wy 2 ай бұрын
Great video . I’ve an issue when using Name from JSON . In the SharePoint when i access the document which is attached to the list item is corrupted . Any advise how to fix this ?
@IGEEAnalytics
@IGEEAnalytics Жыл бұрын
In the Get file content step, I get an error, "Action 'Get_file_content' failed" and "The file id '/Apps/Microsoft Forms/My Folder/filename' is not valid." then the flow does not move to Add Attachment, however, the file is saved to my onedrive correctly. Any ideas?
@mii1563
@mii1563 Жыл бұрын
Im still trying to figure this one out.
@courtneybryson9778
@courtneybryson9778 2 жыл бұрын
Wow thank you so much April. Such a helpful video. I am wondering if you can help me. I have gone through the steps & I am struggling with the Parse JSON section. It says my schema is invalid. When copying the field in my Run History. All of my answers are situated in ''Body'' and are not individual like seen in your video. Does this make a difference to my flow going forward?
@melissaw7
@melissaw7 7 ай бұрын
Great video! It's very close to what I've been searching for. What would need to be added to this process to have the MS Form attachments (for a group form) be added to a document library according to the characters contained in the file attachment name? Example, files that contain the word "blue" are placed in the document library folder titled "Blue." Really hope you're able to help with this. Thanks!
@studiotech6194
@studiotech6194 2 жыл бұрын
What happened if the attachment is not included on the form i am getting error message from Parse JSON how can i stop it please. InvalidTemplate. 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 ''.'. any help
@martiscuola238
@martiscuola238 2 жыл бұрын
thank you very much for your video! I have a question. I have a form where the user can upload 1 attachment or 3 attachments. Unfortunately the flow does not work in this case, I have this error: "The execution of the 'Apply_to_all' action of the model failed. The result of evaluating the expression 'foreach' '@outputs (' compose_output_ buffer ')' is of type 'Null'. The result must be a valid array". How can I do? thank you
@ChingYinW
@ChingYinW Жыл бұрын
Hi April, Thanks so much for this training material! It's so clear to follow with your explaination. But I have a question here when I have one question in Form to ask user to upload attachments, while ppl can upload photos or videos. And I have created the flow per what you have mentioned in the video, but I could only open the photos in SharePoint when the user upload both photo and video in the same Form. And I can open the video when the user only upload video in that Form. If there is anything I have to edit in the flow in order to solve this issue? Thanks so much!
@Ninjaahhhh
@Ninjaahhhh Жыл бұрын
Hello, I was able to get this flow to run successfully for my Group Form, but when I go to the SharePoint item to open the attachment, which in this case, is a Word document, I get an error message that states "Sorry, this document can't be opened for editing." It gives me an option to open in Desktop App, but when I do this, I get an error message from Word states "Word found unreadable content in (name of the document). Do you want to recover the contents of this document?" When I click Yes, I get a message that states "Word experienced an error trying to open the file." I've tried other files such as a PDF and run into similar issues. Not sure if this is a PowerAutomate issue, however, when I go to the folder where the attachment is, I can open it there just fine; it's only when I try to open it from the SharePoint list item I run into issues.
@stephenaliwell6915
@stephenaliwell6915 2 жыл бұрын
I've followed your steps and it just won't work and I don't know why. It's kept stopping at the JSON stage saying something about areay
@maathias9
@maathias9 3 жыл бұрын
Thank you for your video, really helped! If I'd like to take this one step further and have the image that was uploaded from forms show in an approval before I add it to SharePoint (if approved), how would you go towards accomplish this? Thanks again.
@lawrenceslavin4507
@lawrenceslavin4507 2 жыл бұрын
April, I hope I'm not repeating the question. I don't see "Get file content using path" as an available step. Could that be because my government org may have blocked it? Thanks for any input you may have.
@koalajs
@koalajs Жыл бұрын
What if the uploaded multiple photos has the same file name then that returns an error? How do we still capture the uploaded photos and yet rename tham before adding them as attachments?
@patrickcardichon9212
@patrickcardichon9212 8 ай бұрын
Thank you so much April. It worked!
@AprilDunnam
@AprilDunnam 8 ай бұрын
Awesome, glad it worked for you!
@2270thornton
@2270thornton 11 ай бұрын
This is a great video, what is the full schema? When I followed the steps this was in my schema "type": {} and "uploadSessionUrl": {} and is sending an error code. Any suggestions on how to fix this issue?
@davidwcoffin
@davidwcoffin 10 ай бұрын
HI April, 1st, thank you for making these instructional videos. Very good! I'm having an issue with my file upload. I'd like it to show up in the list, but everytime I try to copy the JSON code and place it in the parse sample box it says there are errors. I've tried viewing and following different videos and same issue appears. Any suggestions or thoughts?
@marekmierzynski5834
@marekmierzynski5834 2 жыл бұрын
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?
@dshepherd6085
@dshepherd6085 Жыл бұрын
This works great, BUT now I want to take that same attachment and attach it to an email. Any help would be appreciated.
@mikedziados4308
@mikedziados4308 2 жыл бұрын
It worked for one day and then for no reason it just stopped working. It keeps saying the file path can't be found even though I've checked it over and over.
@sanjeevsingh-em4qp
@sanjeevsingh-em4qp Жыл бұрын
Hello @April Dunnam... How to resolve for word document as attachment, i have even used Concat but still when as a user i try or someone upload word document in attachment , it fails with 404 file not found error. it works fine with png or image , any guidance
@rolaogomes
@rolaogomes 9 ай бұрын
Old But Gold! But I can't find a work around the error if i don't have an attachment in my forms I get an error in the Parse due to null.
@TheVirtualStealth
@TheVirtualStealth 8 ай бұрын
You have to make a true/false condition to prevent the Parse JSON (and the steps after that) from running if there is no attachment/file uploaded.
Move Microsoft Forms Data to Microsoft Lists
16:19
April Dunnam
Рет қаралды 178 М.
How many people are in the changing room? #devil #lilith #funny #shorts
00:39
ТВОИ РОДИТЕЛИ И ЧЕЛОВЕК ПАУК 😂#shorts
00:59
BATEK_OFFICIAL
Рет қаралды 7 МЛН
Deadpool family by Tsuriki Show
00:12
Tsuriki Show
Рет қаралды 3,9 МЛН
How to Fight a Gross Man 😡
00:19
Alan Chikin Chow
Рет қаралды 20 МЛН
Save Email Attachments to SharePoint with Microsoft Power Automate
16:26
A Creative Opinion
Рет қаралды 25 М.
Save MS Form Attachment to SharePoint List using Power Automate
9:52
Lernen Tech (LT)
Рет қаралды 102 М.
Microsoft Forms to PDF without Premium Actions in Power Automate
16:25
The One MISTAKE Everyone is Making with SharePoint
6:21
Jonathan Edwards
Рет қаралды 149 М.
Run a flow when a SharePoint column is modified
9:58
April Dunnam
Рет қаралды 132 М.
Power Automate Tutorial - Microsoft Forms Attachments (2021)
19:26
Jon Levesque
Рет қаралды 24 М.
How To Save Microsoft Form Responses To A SharePoint List
19:09
Lui Iacobellis
Рет қаралды 37 М.
Automate Microsoft Forms Responses into SharePoint Lists with No Effort!
12:00
How many people are in the changing room? #devil #lilith #funny #shorts
00:39