Search Results

    Blog Posts (11)
    • How to retrieve files from a SharePoint library and send an email attachment (with Power Automate)

      Every flow needs a trigger to start with so here I am using a manual trigger. Next, I am using the action List Folder which returns files contained in a SharePoint folder. The return response is an array of BlobMetadata which contains the below properties. NamePathTypeDescriptionItemId (integer) - The value that can be used to Get or Update file properties in libraries. Id (string) - The unique id of the file or folder. Name (string) - The name of the file or folder. DisplayName (string) - The display name of the file or folder. Path (string) - The path of the file or folder. LastModified (datetime) - The date and time the file or folder was last modified. Size (integer) - The size of the file or folder. MediaType (string) - The media type of the file or folder. IsFolder (boolean) - A boolean value (true, false) to indicate whether or not the blob is a folder. ETag (string) - The etag of the file or folder. FileLocator (string) - The filelocator of the file or folder. Next, we need to collect the file name and contents. For this we need to declare a variable type array called FilesArray. Now we need to construct a loop for reading all of the SharePoint library contents. This could be files or folders, so within the loop I am checking whether the content is a folder or not. See image: Now we need to construct the rest of the logic under the Yes condition, and set all of the file's properties to the array variable which we declared earlier. To get the file's content, we use the action Get file content using path. The Path property is available from the above step using the Blobmetadata content. The Append to array variable action will have two properties - ContentBytes and Name. See the setup below. The expression for the property ContentBytes is as follows: body(‘Get_file_content_using_path’).$content Note: There is a property called FileContent available from the Dynamic content, but this will result in an error when sending the email. So it is important to use the above expression for Contentbytes. Finally, outside the Apply to each loop use the Send email flow action for sending all the files as one attachment. Below is the final preview of the flow solution.

    • How to restore a previous version of a Sharepoint document using Power Automate

      A SharePoint Document Library provides a secure place to store files where you and your co-workers can find them easily; work on them together and access them from any device at any time. Restoring a previous version of a document using Sharepoint First lets see how we would do this in Sharepoint. We would go to the document library, select the file and then choose ‘Version history’. Then we would select the correct version to restore to and select Restore. Easy. Now, how can we do this using only Power Automate? First, we will use the Sharepoint API to grab a list of the versions of the document. The URL https://{{yoursharepointsite}}/_api/Web/GetFileByServerRelativePath(decodedurl=’/edu/Portal/Ideas/tips.txt’)/Versions is the one we need to hit. In this URL, ‘edu’ is my SharePoint site, ‘Portal Ideas’ is the library name and 'tips.txt' is my document. We use an HTTP request to call this URL. And then we will use a Parse JSON action to unpack the results. The easiest way to get the property name that we require is to execute the flow step (Send an Http Request to SharePoint), look at the run history and copy the JSON in to the below step (Parse JSON). We setup a variable Comment which is taken from the VersionLabel property in the JSON. Now, to actually restore the document to a previous version we will use SharePoint API again. This time we are calling this URL: https://{{yoursharepointsite}}/_api/Web/GetFileByServerRelativePath(decodedurl=’/edu/Portal/Ideas/tips.txt’)/Versions/restoreByLabel({{Comment variable from above action}}) Hope this was useful.

    • Filtering Excel Rows with Power Automate

      Below is my Excel sheet ProdDetails. Retrieving all of the rows To manipulate this data in Power Automate, first we will retrieve all of the rows: This action will returns all the rows from excel sheet. The maximum size of an Excel file that is supported by the Excel Online (Business) connector is 25 MB. The maximum size of an Excel file that is supported by the Excel Online (OneDrive) connector is 5 MB. Filtering the data Next, we will look at filtering the data. To do this we will use the Filter Query property. This returns three rows where matched Id is equal to 101. If the filter value is a string or alphanumeric then you need to put single quotes around it. See below where I am going to filter for Id A500 Supported filter functions are: eq, ne, contains, startswith & endswith To order the data use the syntax: [Column name] desc/asc Eg: Price order by desc. See below. Top Count This returns the top/maximum number of records that should be returned. Skip Count This is used for number of records that should be ignored. Skip is generally used for pagination which is used for retrieving large amount of data. Thank you for reading.

    View All
    Pages (4)
    • BLOG | Power Platform | Power Automate | Microsoft Flow | Power Apps

      Blog Categories ​ Beginner Intermediate Advanced ​ Power Automate Essentials ​ ​ ​ ​ ​ ​ How can I help you? ​ I am happy to help at any time. You can contact me via the official . Tag me (@abm) on any post you make there if you would like to me take a look at it. PowerAutomate community forum ​ I am always available for both corporate training or 1-2-1 training for individuals. Get in touch // ajith.madathil@outlook.com

    • ABOUT | Power Platform | Power Automate | Microsoft Flow

      ABOUT Who I am Hello, my name is Ajith Madathil. I have been fortunate to work with Microsoft technologies for many years now, going all the way back to MS-DOS, Windows 3.1, through the .net Framework, Power Platform, C# and onwards. Currently I am working with Power Automate, Power Apps, D365 CE, SharePoint & Microsoft Azure. ​ In October 2019 I was awarded the title of 'Power Automate community super user' (AKA a Flownaut) for my contributions to the Power Automate community forum by Microsoft. My Power Automate community profile name is 'abm'. ​ My Profile Page https://powerusers.microsoft.com/t5/user/viewprofilepage/user-id/2721 ​ Power Automate - Super User Announcement https://powerusers.microsoft.com/t5/News-Announcements/Meet-Our-Power-Automate-Community-Super-Users-Flownauts/td-p/386220 ​ Power Automate Community: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity ​ My Twitter handle: @mydevexperience Why do I do this? ​ "When one teaches, two learn" - Robert A. Heinlein ​ I am a big believer in sharing knowledge. So far I have authored more than solutions for the Power Automate community forum. At the same time I have learned a lot from the community as well. 300 ​ What I can do for you ​ I can help you to automate a business process using Power Platform. If you looking for any training (Individual/Group) or consultancy in Power Platform (Power Automate / PowerApps), D365 & SharePoint, then please get in touch with me. ​ Contact me via email please click here ​ Contact me via Power Automate @abm

    • Post | Powerauto

      We Couldn’t Find This Page Check out some of the other great posts in this blog. See More Posts Blog Categories ​ Beginner Intermediate Advanced ​ Power Automate Essentials ​ ​ ​ ​ ​ ​ How can I help you? ​ I am happy to help at any time. You can contact me via the official PowerAutomate community forum. Tag me (@abm) on any post you make there if you would like to me take a look at it. ​ I am always available for both corporate training or 1-2-1 training for individuals.

    View All

© 2023 by Walkaway. Proudly created with Wix.com

  • Twitter Black Round
This site was designed with the
.com
website builder. Create your website today.
Start Now