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....
Continue reading...Flow
SharePoint Get Items and Filter Query in Flow [Part-3].
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...
Continue reading...SharePoint Get Items and Filter Query in Flow [Part-2]
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...
Continue reading...SharePoint Get Items and Filter Query in Flow [Part-1]
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...
Continue reading...How to send reminder email to a SharePoint group users?
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...
Continue reading...Power Automate : Reminder
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...
Continue reading...How to transpose Excel table via flow?
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- Steps- I am using flow...
Continue reading...