In this Power Automate video tutorial, I have explained power automate sharepoint get items filter query examples. Here, I have show 7 different filter query examples of Get items flow action in Power Automate. They are related to date, date range, choice field, created date, greater than or equal
, etc.
Here are the filter query:
1. StartDate ge '@{formatDateTime(addDays(utcNow(),-7),'yyyy-MM-dd')}'
2. StartDate eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}' and EndDate ge '@{addDays(utcNow(),60,'yyyy-MM-dd')}'
3. CoursePeriod gt '5'
4. CourseType eq null or CourseFee eq null.
5. CourseAdmin/Title eq 'Lidia Holloway'
CourseAdmin/EMail eq 'LidiaH@szg52.onmicrosoft.com'
6. startswith(Title, 'S')
7. StartDate le '@{utcNow()}' and CourseType eq 'Power Automate' and (CoursePeriod ge '6' or CourseFee le '1000')
#powerautomate #sharepointonline
==========================================
Want to Learn Complete SharePoint Online development? Check out the complete SharePoint Online developer training (Course Bundle): sharepointsky.teachable.com/p...
==========================================
Check out the Previous video on how to use get items flow action in Power Automate. • Filter SharePoint List...
Here are a few tutorials:
Power Automate Get Items Filter Query Date sharepointdotnet.com/power-au...
Power Automate Get Items Filter Query Multiple Conditions sharepointdotnet.com/power-au...
==========================================
Related Video Tutorials:
How to call rest api from power automate • How to call rest api f...
Scheduled Cloud Flow in Power Automate • Scheduled Cloud Flow i...
Send Email Based on Due Date in SharePoint List using Power Automate • Send Email Based on Du...
==========================================
For More FREE Video Tutorials, Subscribe to Our RU-vid Channel ru-vid.com...
==========================================
//Playlists
Power Apps Tutorials Playlist • Microsoft PowerApps | ...
Power BI Tutorials Playlist • Microsoft Power BI | P...
Power Automate Tutorials Playlist • Microsoft Power Automa...
SharePoint Framework (SPFx) Tutorial • SharePoint Framework (...
==========================================
Let's Connect
LinkedIn: / fewlines4biju
Twitter: / fewlines4biju
Facebook: / fewlines4biju
Microsoft MVP Profile: mvp.microsoft.com/en-us/Publi...
==========================================
Our Web Sites:
www.SPGuides.com
www.EnjoySharePoint.com
==========================================
21 июл 2024