Gopenly

  n previous part , we have seen the basic concepts of cloud computing in Azure. Now in this article we will see benefits of cloud computing. This series is based on Microsoft Learning path specifically designed for Azure fundamentals. Part-1B : Benefits of Cloud Computing When building or deploying a cloud application, two most important observations should be considered- Availability/Uptime : Azure is a highly available cloud environment with uptime guarantees depending on the service. These guarantees are part of the service-level agreements (SLAs). For more information please visit :  Azure Fundamentals and Certification [AZ-900] Series-Part(2) | (gopenly.in)

  Why Azure? Organizations across the globe are now realizing the benefits of Cloud computing. They are redefining the  new way of doing business with scalable & secure cloud-enabled enterprise applications. Using Azure cloud services, organizations can rapidly build, deploy, and manage simple to complex applications. Today, Azure cloud platform is having more than 200 products and cloud services where you can build, run, and manage applications across multiple clouds, on-premises, with the tools and frameworks of your choice. Of the Fortune 500 companies, 95 percent rely on Azure for trusted cloud services. Companies of all sizes and maturities use Azure in their digital transformation. To understand Azure better, Use  Microsoft Learning path  specifically designed for Azure fundamentals. In this series, we will cover fundamental concept of Azure which will help you to crack AZ-900 certification and will provide you basic foundation of Azure concepts. For more d...

  W hile creating a cloud flow you may encounter some need of conditions/expressions for logic building. You can use condition card in basic mode to quickly compare a single value with another value. Note:   You can add up to 10 condition rows under one logical value.  To add more rows under one logical value, first add group then ungroup that group you .... For more information Please visit my site:  How to use expressions and conditions in Power Automate/Flow? | Gopenly

  In this Approval series we will send reminder for Approval flow. We know how to created a simple approval flow? . but what happened if you are waiting for a long time for your request to be approved. As i have already mentioned in my part 1 of this series, by default Reminder can not be configured in Approval action. Here we will create reminder for approval flow. So, we have created a SharePoint list called Leave Management. when employee submits a leave request, then approver(manager) gets a request via Outlook mail/Microsoft Teams notification. If the manager approves (accept/reject) the request, then the requestor gets the response mail in Outlook and the request gets updated with the current status. Sometimes, employee waits for a long time for approval, in that case, we will send the reminder mail to.. For more details, Please visit my site :  How to setup reminder in approval flow?[Part-4] | Gopenly

  We know that Microsoft forms is very easy to design and collect responses. But it becomes very handy when you include Microsoft forms connector with flow and save responses in a SharePoint List. Power Automate has trigger " When a new response is submitted ," and one action, " Get response details ".  This action pulls in the details of the form response as dynamic content that you can use in your flow. Use Case - When user submit form responses then responses will be recorded into a Sharepoint List. For more information, Please check my site:  How to store Microsoft forms responses in a SharePoint list? | Gopenly

  In my previous two articles i have explained about the basics of an approval flow and how you will create simple approval flow. If you did not see my previous posts then i would recommend you to see my previous approval series  Part 1  and  Part 2  before proceeding further. Use Case- When user will create one leave request in SharePoint Leave Management List, it will go for approval to his/her manager. Once manager approved/reject we will notify to user for their leave request  along with manager comments.  Comments are... For more details, Please visit my site:  How to capture comments in approval flow? [Part-3] | Gopenly

In my previous article , I have explained about approval process. Now we will see how to create a simple approval flow using power Automate. Use Case- When user will create one leave request in my Leave Management List, it will go for approval to his/her manager. Once manager approved/reject we will notify to user for their leave request along with manager comments. For more information Please visit my site:  How to create a simple approval flow?[Part-2] | Gopenly  

  Today, Approval process is a part of every organization. Approval processes standardise organization’s internal process. Approval process could be either for leave or for some expense report. In Power Automate, when we use approval action, approvers are notified and they can review and act accordingly. In flow, we use approval actions which will perform actions after trigger starts the flow. For example, when a new item is created to a SharePoint list then trigger an approval flow for somebody who can review the newly created item. For more information Please visit my site:  What is an Approval flow in Power Automate(MS Flow)?[Part-1] | Gopenly

  In my  previous post , i have explained Filter query in details. Now i will cover up some most useful filter query syntax examples. Filter Query Examples in SharePoint Get items action- Working with dates:  In filter query, date value must be in same date format of your column date format. you can check your column date format by simply running your flow. Once your flow run successfully, Expand your get items action and check output by click to download link. This will open a new tab where you can search your column name. For more details, Please visit my site:  SharePoint Get Items and Filter Query in Flow [Part-3]. | Gopenly

In my  previous post , I have explained basic details of Sharepoint Get items. Now in this article, i will cover up more details about   Filter Query . Filter Query in Get items- Within the SharePoint Get items action there is a Filter Query . This Filter Query can be used to select the required items. As a citizen developer, Filter query syntax is not clear and how do we use it?. So filter query syntax is like this- Column Internal Name   Operator   Value SharePoint Column Internal Name:   For filter query it is important to use SharePoint Internal column name to fetch required list items. But some times users are not able to figure out what is SharePoint Internal column name?. To get Internal column name,  Go to List/Library settings  then  click on your required column name . For more details, Please visit my site:  SharePoint Get Items and Filter Query in Flow [Part-2] | Gopenly  

  In Flow, Get Items is a SharePoint action which allows you to get items from SharePoint list. Similarly There is another SharePoint action called Get files which allows you to get files from Sharepoint document library. You can not use Get files for SharePoint list but the capabilities for both the actions are same. Important Points- The default item limit is 100. Items are paginated by default. For larger list, you can increase this limit up to list view threshold limit of 5000 items.  Flow will generate error dialog if you are going beyond 5000 limit. For more details, Please visit my site:  SharePoint Get Items and Filter Query in Flow [Part-1] | Gopenly

  In my  Previous post , I have explained basics of the Reminder flow. Now we will understand how to send reminder for users who are part of a SharePoint group. Advantage of this reminder is that you can easily manage users in your SharePoint group. Use case- Reminder for specific group of users to provide inputs weekly for example their availability for interview slots. Steps- Since this is a reminder flow so my trigger would be ‘Recurrence’ . you can set your interval and frequency for recurrence. We will initialise 3 variables –  Group (Type-String), i (Type-Integer) and Users (type-Array). For more details Please my site:  How to send reminder email to a SharePoint group users? | Gopenly

  Creating a reminder flow/ Scheduled Flow is a basic use of Power Automate. Reminder itself bind with Date & Time which you need to decide. In Flow, we have one trigger for reminder-  Recurrence . In Recurrence, We need to understand following advance options- Frequency- Frequency is based on time period like seconds, Minutes, Hours etc. Interval-  is number of times your flow will send reminder in defined frequency. Time zone-  Select your territorial time zone so that flow could triggered on defined time. Start Time-   This is the time when your flow will first trigger. it should be greater than or equal to  current time. it will be in this format-YYYY-MM-DDTHH:MM:SSZ For more details Pls visit my site:  Power Automate : Reminder | Gopenly Hardesh

  Have you ever build Power Automate (Flow) for transposing Excel table?. I came across such problem and designed a flow.  This flow transpose your excel table data. I have one excel sheet- Sales Data inside SalesTable. It has three columns- 1. CustomerID 2. Category 3. Sales. I want to transpose above table into following format- For details please visit my site:  How to transpose Excel table via flow? | Gopenly

  In  Power Automate Community , i have seen lots of user face issue with getting attachments from SharePoint list via flow. Today i will explain how you can retrieve multiple attachments from SharePoint list and then send those attachments in email via flow. So i have one SharePoint list-  Holiday List  where user needs to upload travel documents for booking. Here i am attaching dummy documents like passport & Visa. Once i save documents in list then my flow will trigger and send documents as attachment in email. One important step in this process is you need to create attachment array where you need to add... For more details please visit my site URL:   How to get attachments from SharePoint list and then send in email via Flow? | Gopenly

  In my  previous post  I have given very basic intro about Power Automate and today i will cover how many types of flow you can create. Before moving to the types of flow There are two ways to create flow- Start from template Inbuilt templates From visio templates For more details, Please visit my site URL: Power Automate: Types of Flow [Chapter – 2.0] | Gopenly

Initially we have SharePoint Designer to create workflow in SharePoint. But SharePoint designer limitation was that it was  integrated with one product i.e., SharePoint. With Power Automate Microsoft integrated other products like-SQL, Twitter, FB etc. So Power Automate (previously know as MS Flow) is a kind of service that helps you to- Automate repetitive business processes. Send reminders on past due tasks. Move business data between systems on a schedule. Automate tasks on your local computer like computing data in Excel. All of this can be done by all skill levels from typical business users to IT using Power Automates no-code/low-code platform. For more details visit my site URL: Power Automate: Flow Introduction [Chapter-1.0] | Gopenly

  In  SharePoint Calculated Column, A formula starts with an equal sign (=) like we do calculation in math. In   create column page   you will see one dedicated space for writing formula, where you will write formula for calculated column. Though you can use  other formula & function  in calculated column but we usually face difficulty with Dates so i am covering here some important dates formula for calculating column. Adding/Subtracting to a date Add number of days to a date-  A dding 30 days in my Project Start Date column For more details pls see my site URL:  SharePoint Calculated Column formulas based on Date and Time | Gopenly

In Microsoft Power Automate Community, i have seen lots of post regarding “How to save MS Forms multiple choices to SharePoint List?”. Problem with Multiple choices is that it gives you output in array format like [“Paris”,”Berlin”,”Milan”]. We can store this output in our SharePoint List but it is not a clean output for look and feel. Today i will show step by step process to store ms form multiple choices to SharePoint list via Flow. Prerequisites-  I have one MS Form-  Holiday Survey  which will collect travellers preferred location for holiday. I have one SharePoint List-  Holiday List  which will store preferred location. For More details, Please visit my Site URL:  How to store MS Forms multiple choice to SharePoint List? | Gopenly

  In my previous post, where i have explained “ What is a calculated column in SharePoint? ” and now i will show how calculated column will be created in SharePoint List/Library. Steps- Go to your SharePoint List/Library. Click on  +Add column  then Click on  more..  This will redirect to a create column page. For More details please check my site URL :  How to create calculated column in SharePoint List/Library? | Gopenly