MS Power Assist

In this post, let us see how can we get the old files from a SharePoint Folder using Power Automate. In this example, I am considering a simple approach and this can be extended based on the requirement. To ensure the Power Automate is simple, efficient and the performance is optimized - we are not using ForEach control to loop through and identify old file or item.  We use " Send an HTTP request to SharePoint " in the Power Automate and query the data using OData filters and order by.  The idea here for the faster retrieval - selecting only a required set of fields from the file. Steps to achieve this: Login to https:make.powerautomate.com . New Cloud Flow -> Scheduled Or Instant (based on the requirement). (Configure the Start Date and Time. For repeat, every, configure the seconds/ minutes/  hours/ day/ week/ month) Click on Create Button. Click + icon to add new action. Search for SharePoint and select  " Send an HTTP request to SharePoint " Select the re...

In this post let us how to embed an image in an email using Power Automate In order to embed an image in an email - it would be easy if the image is stored in OneDrive or SharePoint folder and retrieve them. Let us see how to accomplish this... Create a folder in OneDrive for Business Upload an image to embed in email Now, let us create flow. Add a trigger Add a variable (this helps us to form the image tag to embed in email) Add OneDrive for Business connector and chose "List files in folder" Add "Get file content" and File field add - "Id" from the above action Now add "Get File Content" action from OneDrive for Business connector Under File field - select "Id" from the dynamic content Apply to each automatically applies when you add "Id" into File field. Now add "Set Variable" and update it's Value as <img src="data:image/png;base64, @{body('Get_file_content')?['$content']} " alt=...

In this post, let us see how to implement " Nested Flows " in Power Automate.  Some use cases: To create a common logic and make use of "Run a Child Flow" action To perform actions on the database without providing access to the end users. Let us create records in SharePoint (using Student Name and Email fields in this post)  without providing access to the end users using nested flow concept. To proceed, we need to have two flows created.  Parent Flow (which triggers the child flow) Child Flow (nested Flow) Go to flow.microsoft.com, log in and select respective environment from the drop-down. Click on "+ Create" Choose "Instant flow" Provide a name and choose " When an HTTP request is received " and "Create" Now, we need to provide inputs to the flow (inputs from the Parent Flow) We need to generate Schema for " When an HTTP request is received" trigger Click on "Use sample payload to generate schema" and...