Save Forms 📝 & Attachments📎 in a Sharepoint List

Поделиться
HTML-код
  • Опубликовано: 30 окт 2021
  • In today's video, we will create a Microsoft Forms Application with Attachments. Next, we will go on and create a SharePoint List to save the responses as an Item and the attachments from the Form as an Item Attachment. The responses will be captured by a Power Automate Flow and saved on trigger in the SharePoint List.
    If you want to learn more about Power Apps in cooperation with SharePoint, you are welcome to follow the channel and subscribe to the playlist here: / @enea
    Feel Free to follow me on other social media platforms as well:
    linktr.ee/EneaLicaj
    Buy me a pizza 🍕- bmc.link/enealicaj
  • НаукаНаука

Комментарии • 60

  • @ne1ste
    @ne1ste 3 месяца назад

    Great video - I've been trying for days to get my flow to do this and your video is the only one that I was able to clearly follow. Thanks so much!

  • @nichakan2000
    @nichakan2000 4 месяца назад

    Easy and got results thank you so much

  • @jfernandez7176
    @jfernandez7176 9 месяцев назад +1

    Excellent video. Have seen many in trying to accomplish these steps and YOUR VIDEO was the one that made it work on my side... so THANK YOU SO MUCH!!!!

    • @Enea
      @Enea  9 месяцев назад

      Thank you! Happy that I could help :)

  • @SanketShahs
    @SanketShahs 3 месяца назад

    Enea, I tried a few tutorials and a couple of other RUclips videos, but your steps were very clear to me and it worked like a charm! Thank you!

    • @Enea
      @Enea  3 месяца назад +1

      Thanks for your feedback! Subscribe if you like

  • @stephaniatrejos2852
    @stephaniatrejos2852 7 месяцев назад

    This was so HELPFUL! Thanks Enea! ☺

    • @Enea
      @Enea  7 месяцев назад

      Happy I could help! Feel free to subscribe if you like, it will help the channel as well :)

  • @WychfinderYT
    @WychfinderYT 2 года назад

    Enea, thanks for creating this video. I found it very clear and easy to understand and have successfully applied it to an example of my own.

    • @Enea
      @Enea  2 года назад

      Thank you Adrian! Happy to help :)

  • @TranceMatzl15
    @TranceMatzl15 2 года назад +1

    Thanks man, your video was the first one that actually worked for me! Spend hours on troubleshooting other tutorial-flows before😂

    • @Enea
      @Enea  2 года назад

      Happy to hear that! Subscribe to the channel if you like my content, would mean a lot :)

  • @lawranceamburose2034
    @lawranceamburose2034 Год назад

    Thank you for sharing this video.
    Clear explanation and it's working !!

    • @Enea
      @Enea  Год назад

      Happy I could help :)

  • @nibbanasuwaya
    @nibbanasuwaya 9 месяцев назад

    Thanks ...your shearing ...Sri Lanka

  • @aumit7
    @aumit7 Год назад

    This is a good one! Thank you!

    • @Enea
      @Enea  Год назад

      Thank you!

  • @mikecorrigan5166
    @mikecorrigan5166 2 года назад

    Very helpful. Thank you.

    • @Enea
      @Enea  2 года назад

      Happy I could help. Subscribe if you like the channel, would mean a lot. :)

  • @muhammaddzakysyahputra6714
    @muhammaddzakysyahputra6714 2 года назад

    thanks brother, you help me for the problem :D

    • @Enea
      @Enea  2 года назад

      Happy to hear that :)

  • @caseyunger8907
    @caseyunger8907 Год назад +1

    I am following this process but with a group form I created. When doing the get file content command I get an error message saying the resource could not be found. The form attachments submitted from group forms seems to save to the team it's a part of. Any ideas on a work around to get these attachments to list items?

  • @musikafeels5637
    @musikafeels5637 2 года назад

    Thank you so much! I have tried different methods and still cant get it. this one is the simplest and works!

    • @Enea
      @Enea  2 года назад

      Happy to help, subscribe to the channel if you like :)

  • @rodrigovargas9647
    @rodrigovargas9647 2 года назад

    Hey man thank you so much!!! Question tho I use form and don’t require attachment all the time so I’m seeing that the ones that don’t have attachment are getting an error. Any idea how to fix this?

    • @Enea
      @Enea  2 года назад

      Hi Rodrigo, thanks for the comment. I haven’t experienced that issue, I would then build a condition before the creation of the item that checks if the form has an attachment or the attachment section is blank. Let me know if you need any help.

  • @agneswang2782
    @agneswang2782 Год назад

    This is so helpful thank you! On the "Create Item" one, is there a way for me to use the form attachment name for the title column?

    • @Enea
      @Enea  Год назад

      The from attachment name will create a loop. If you only allow one attachment, then is no problem, you can go on and use it.

    • @agneswang2782
      @agneswang2782 Год назад

      @@Enea Thanks for the response! Somehow the "title" field in the "Create Item" workflow will not allow me to use a dynamic value. I can send you what I have via email. Would you be willing to help me take a look?

  • @allanleite270
    @allanleite270 Год назад

    Great video!! Help me a lot. And about two or more question type with attachments in forms? and saved in list? How i can do this? Tks

    • @Enea
      @Enea  Год назад

      Happy it helped. Unfortunately I do not understand your question, please try again :)

  • @deasuluashvili2208
    @deasuluashvili2208 2 года назад

    Hello! it was very very helpful. thanks! is there any way to store all those attachments in the same folder?

    • @Enea
      @Enea  2 года назад +1

      Hi Dea, happy to help! Libraries are nothing else than folders. You can create a folder and redirect the path to that folder. If you want the folder to be dynamic then you need to describe me the process first and then I might do a video for your use case.
      If you like my videos, feel free to subscribe to the channel :)

    • @deasuluashvili2208
      @deasuluashvili2208 2 года назад

      Yes, I will subscribe. Good luck

  • @akhilreghunath
    @akhilreghunath Месяц назад +1

    Thanks Enea for the video.
    However my flow is creating two row items in list while using this method, one row items with an attachment and another one without sn attachment. Could you pls help me to solve this.

    • @Enea
      @Enea  Месяц назад

      Hi, thanks! The Workflow works as its built in the video. If there is something wrong please watch it again. Check again the moment in the video where I add the attachment to the item. You must be doing something wrong at that section

  • @marigonaidrizi6816
    @marigonaidrizi6816 4 месяца назад

    Hello Enea, thank you for this video ! Question what do I have to do if the upload section of my forms is not is not mandatory ? When I put something it add a ligne in the sharepoint list but not if i put nothing. Thank you or faleminderit per pergjigjen

    • @Enea
      @Enea  4 месяца назад

      Pershendetje Marigona, faleminderit per komentin! :)
      You should place a condition and check if a file has been uploaded or not. If yes do it like in the video, if not then modify it so that just a new item is created with the data from the forms fields. Makes sense?

    • @marigonaidrizi6816
      @marigonaidrizi6816 4 месяца назад

      Shum qart. Faleminderit shum :) !@@Enea

  • @francesfemille
    @francesfemille 7 месяцев назад

    Is there a way to post in a message the attachment in sharepoint list?

    • @Enea
      @Enea  7 месяцев назад

      Post it where?

    • @francesfemille
      @francesfemille 7 месяцев назад +1

      Post it to a Teams Channel@@EneaI basically just want the upload files from MS Forms to Teams Channel. Is it possible?

    • @Enea
      @Enea  7 месяцев назад

      @@francesfemille it should be. Let me test it out and might make a quick video if I manage to do it

    • @francesfemille
      @francesfemille 7 месяцев назад

      @@Enea Ah perfect! I really appreciate that. Thank you so much. I have searched youtube and no video relating to this specifically. Yours might be the first if ever. Been struggling for weeks now. :(

    • @Enea
      @Enea  7 месяцев назад

      @@francesfemille, quick question, should the attachment be posted as a message in the channel chat or somewhere more spesific?

  • @KomailButt
    @KomailButt Год назад

    Excellent work bro. Can I save the attached file in Document Lib ?

    • @Enea
      @Enea  Год назад +1

      Of course, instead of adding it as an attachment to an item, do a „create file“ directly :)

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

    • @Enea
      @Enea  2 года назад

      You should create a condition before the file creation to check if the attachment is empty. If yes, terminate or notify someone. If no create the file like in the video

    • @studiotech6194
      @studiotech6194 2 года назад

      @@Enea do you have any video about it please?

    • @Enea
      @Enea  2 года назад

      No, but its just a condition. You can make it 👍🏻

  • @muhammaddzakysyahputra6714
    @muhammaddzakysyahputra6714 2 года назад

    The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: The API operation 'PostItem' requires the property 'item/attach' to be a string of maximum length '255' but is of length '543'.
    how we solved this problem ? thanks before for reply

    • @Enea
      @Enea  2 года назад

      The column you are trying to save the name of the attachment is a single line text field and accepts up to 255 characters. Either shorten the title or save it in a multiline text column. Hope it helps

    • @muhammaddzakysyahputra6714
      @muhammaddzakysyahputra6714 2 года назад

      @@Enea it help, thank you so much bro. but, can you make new video about " how use initialize variable" because i still dont understand why we use" string/bolean/integer/float/object/arrat" thankyou

    • @Enea
      @Enea  2 года назад

      ​@@muhammaddzakysyahputra6714,
      imagine variables as a ticket. You initialize a variable (create a ticket) and give that variable a type (string/boolean/integer/float/object/array or imagine the ticket being for museum,cinema,etc.). This means that variable can only be used with that type of data, you cannot save string values in an integer variable (with a cinema ticket you can only go to the cinema, not to the museum). This was initialize a variable, you just created an empty variable with a data type.
      Then you have set variable, this is where the allowed value will be saved into the variable. If you are using the variable to save a text, with this action you can put the text into the variable. (Imagine now putting the name of the person in that ticket you bought).
      You also have append to variable, this can be append to string or append to array. Append is usually needed when you run through a loop and want to add values into the variable. A normal set variable action in a loop would replace the value each time. An append would make that value with each run bigger and put the new value after the value from the run before.
      Hope this helps!
      Enea

  • @borckiborcki5758
    @borckiborcki5758 2 года назад

    Hi Enea, ich sitze aktuell vor meinem Flow und bin doch etwas am verzweifeln.. Ich habe eine ms forms datei erstellt welche über eine sharepoint seite geht, sprich alle eingeschickten anhänge werden auf dieser seite unfreiwillig gespeichert (eigentlich wie bei onedrive).. Nun wollte ich einen flow bauen welcher wie ein normaler flow funktioniert (als wenn man diesen für onedrive etc. nutzt) leider bekomme ich wenn ich bei "get file content" den sharepoint libary auswähle immer nur den fehler "file not found error 404" ich würde ja gerne ein bild (als link) mit hochladen aber dann würde der kommentar gelöscht werden.. Ich hoffe du kannst mir weiterhelfen :) .. aus deinem ersten Video weiß ich das du zum glück deutschprachig bist ^^.. Gruß

    • @Enea
      @Enea  2 года назад

      Hi, grüß dich! Kannst du mich auf LinkedIn oder Facebook kontaktieren und ich kann mal drüber gucken. Dann kannst du auch ein Bild schicken :)