Save Initialized Attachment with airSlate SignNow

Save initialized attachment

[Music] hello today I got a question from one of my students I knew Demi in Microsoft flow crash course the question is about how you can get an attachment or attachments from a SharePoint list and bring it to flow I thought probably that's a good idea for a YouTube video so I replied them back and I decided to put a video together to show it so everybody can see and learn let's get into it turns out to this question I decided to put a simple scenario together I created a SharePoint list of type issue tracking that when the item is created it fires the flow this flow should not only pick up the list item but also it should check if the item has attachment and if so it should pick up the attachments package everything together in an email the email subject should be the title of the issue the email body should be the description of the issue and every attachment to this issue should be email attachment and email should go to the email address that I specify in the flow so let's summarize the issue title will be email subject the issue description will be the email body and all the item attachments will become email attachments before it goes out so fasten your seat belts because this is a juicy one this is the SharePoint list that I created so if I click on new you will see there is title assigned to issue status and all those things so it also has a description field and if I scroll down to the bottom you will see for this list adding attachment is enabled so if someone clicks on add attachment he or she can pick up one file or to file for a couple of files and make the attachment to this list which is the topic of our demo let me cancel this being start by creating the flow so I go to the flow designer float at Microsoft com you login with your Microsoft account and I click on my flows again I create a flow from scratch instant from blank and I click on skip and I need to make a trigger to SharePoint so I click on SharePoint and I'm looking for great so when an item is created in SharePoint I need to pick up the SharePoint site URL if I click on this drop down it loads the site URLs that have been already loaded if you don't find it here and this is the first time that you're going to that site you scroll down click on enter custom value and we go back to our SharePoint and I get the site URL and add it to my flow then I need to pick up the list the list name is IT issues so if I come here I can click on this drop down and you don't see the list here sometimes flow designer is not that smart so enter custom value you need to type it in yourself so IT issues and I tab away everything is in good shape I also need to give it a name I call it the IT issues alert the next step we need to check if this list item has attachment so if I click on new step I need to put a condition so I click on condition and I need to check the value of has attachment from one item is created so I click on here and if I scroll down you will see there is a property called has attachment I don't want to use it the way it is because sometimes this flow designer uses this value as a string and it causes lots of confusions that the whites not following the way it should so let's be safe from the beginning and instead of just picking it up directly from here I click on expression and I type in boolean and I casts it right from here to the right data type this time I scroll down and I go to has attachment click and I click OK no I'm safe now if I click on the other side I just need to click on expression and type true I pick up the value I click on OK I'm safe in this one so if the value of has attachment is true this side of the condition should execute this is the time that I actually need to read the attachment so I click on add an action and I search for SharePoint click and if I scroll down you will find get attachments so again I need to add the site URL this time I pick it up from the drop down list name hopefully this time no no hope I click on it again so I call it IT issues and for the ID the item that I need to get the attachments is actually the ID of the item that has been inserted on the first line so I click on this ID and under winner item is created control if I scroll down you will find ID here so so far I got the attachments of the item that has been added assuming this item has attachments let's see what this guy this get attachment is going to give to us but before we go there the name of this action clearly tells me that it should return a couple of items so basically the next item is going to be a for each loop that navigates through every single item so I click on an action right under get attachment and I search for each so apply to each is my for each loop and if I click on this you see from the get attachment I only get the but what does this body contain my first impression was that okay it should give me the file name and whatever that is inside a fire so let's examine that I add an action and right under it if I say Campos I really don't need the compose to make this work I just want to examine the values that I'm getting it so I click on here I have the current item for apply to each and if I scroll down under get attachments I have the body I have the display name ID and item no sign of file content so let me get the body and see what is inside body maybe it helps so let me save it and go to SharePoint and add an item I call it test zero one for the description I put some random characters and I click on attachments I pick up one file I click open and I click Save logically this should fire the flow so now if I go here if I go under my flows and I click on it I can see the run history that it says succeeded so if I click on it I can go under condition and you see it's taking the right path apply to each then expand it compose actually has one item which is perfect and if I scroll down you will see it has a display name which is perfect but no trace of foil content there's not a good sign so it means we need to take one more step to actually get the foil content so let me click on edit now and add the elements that we need to get the file so let's get back here and if I expand it right after I you read the attachment I need to read the attachment content inside the loop for every single one of those attachments so let me expand this one add an action again I go to share point click on SharePoint and this time I am searching for content so this time I am looking for get attachment content I know you were hoping that things are gonna be easier with flow but this one is not so let me just click on drop down again I pick up my site list name again it doesn't pick it up that's okay I say IT issues and the ID of the item that I want to get is the idea that I'm getting from when an item is created so when an item is created I have the ID for this one and for the file identifier is the attachment identifier so it should come somewhere from get attachments so if I click on get attachments you see there is an ID here for the file so I click on this so I'm good to go so now this one actually gets the content of every file that the flow reads from a list item let me save this and again if you want to examine it inside a compose I can remove this body this time I scroll down here get attachment content if I click on attachment content I can click on save and let's get back to SharePoint and test it here you I call it test two and assign to myself description doesn't really matter at this point I click on add attachment and I pick one file open and I click Save the second file is added so I'm not sure if I save it I hope so so this time if I come here i click on this condition is good I expand the for each loop and get attachment content is added so if I click on content you will see the content directly doesn't contain the file content it has actually an element inside it called dollar sign content this is very important because without this you will not get the file I take a screenshot of this because we need to get back to it now let me go back to edit and we need to move forward after we read all the files after this for each loop right out of it I can send a email so let me search for send email I click on send an email the email address is gonna be my famous email address I use it for every project the subject is going to be the subject that I get from when an item is created this is going to be my title click the body if you remember it's gonna be description so click now here's the complex part when I expand this attachment even you should add them one by one here programmatically hard-coded which is not what we have because we really don't know how many attachments are coming from the other side the second way is if we click on this button here switch the input entire array it gives us the chance to populate an array and assign it to the email in one shot so again we need to go back in this loop we need to populate an array with file name and the file content and then we should assign that array to this variable or this attachments collection let's go up and do it if you need to do it before this condition so I click on here add an action and I search for variable variables and I create and I click on initialize variable this variable I call it attachments type is going to be array and there is no initial value I'm happy with that safe now when I go to my condition when I come to apply to each after I read every attachment content I should be able to add an element to that array so array if I scroll down one of the controls that I have is append to array variable I click on this and I pick up the array that I have which is called attachments the value is a little bit trickier the value is adjacent value the first parameter is going to be the name or actually the file name and because this is jason the property name is going to be in double quote and the file name if you remember is coming from get attachment and if I scroll down you have display name I put my comma this is classic Jason I go to the next line and the second element in this JSON object is going to be content bytes and for the content bytes is the part that it gets a bit tricky for the content byte assumption is that we are getting it from yet attachment content but if you remember the attachment content attachment content does not contain the values directly under that there is an element called content or dollar sign content that it actually has the value so let's get back here and for this one we need to go to the expression and this is the trick that I usually use to utilize this intellisense to make my life a little bit easier I usually put a string here and now I can get the variable called attachment content so if I click on this one you have the body of get attachment content but this is not what I need I need dollar sign content of this variable so let me get rid of the string because I just added this to track the intellisense so this is what we have body get attachment content dot dollar sign content this is what you need here and again if I go back here so this is my get attachment content body under that there is an element called dollar sign content this is what we need exactly like JavaScript syntax so I come back here and I click on OK so body is added so I have the name and the body all the items are added to the array at this stage I scroll down maybe save again and now when I want to send an email I go to the attachments I pick the attachment and I add the attachments which is the array that I populated with the file name and the file content let's save it and I guess we can test it out let's go here add new I call it test with actual attachment assigned to myself description is going to be please take care of this one okay and I click on add attachments and I add three files this time open scroll down click on save and we go back to our flow I click on this one it says succeeded if I expand it it has everything but the main thing is if we can see the files in the email so we are in our mailbox if I click on this then you see we have three attachments so if I click on it all these three files are here always when you test an attachment click on it open it make sure that the content is actually there and the file is healthy this was a complex question having this question coming from one of my students from Microsoft flow crash course that was actually designed for beginner level was quite a surprise for me but anyway I'm actually working on another course that goes deep into all these expressions and the internal elements of Microsoft flow and how to do these complex things rather than just working with the visual tools my plan is to release it before end of july 2019 at the moment if you are new to flow and you want to learn flow flow from scratch the course that I have called Microsoft flow crash course is available on udemy and if you click on the link in the description you will also get the discount coupon embedded in the hyperlink if you are not already a subscriber please click on subscribe so you will get a notification when I'm releasing the future videos mainly related to flow and SharePoint thank you for watching