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/SPO
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...How to extract value from SharePoint Multiple Choice Values column in flow?
Recently, one of the Power Automate Community member bring my focus to SharePoint Multiple choice values. He wants to incorporate multiple choice values in an email from SharePoint list multiple choice column. Problem is that the output from multiple choice values is not straight forward. You need to collect value then format your output in neat and clean way. Here...
Continue reading...How to get attachments from SharePoint list and then send in email via Flow?
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...
Continue reading...SharePoint Calculated Column formulas based on Date and Time
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...
Continue reading...
