Low to Pro - Query Filters+ | Power Apps Tutorial

   In this episode of Low to Pro, Ace Phillips demonstrates how to elevate your flows by using Dataverse filter queries. He explains how to handle complex data types such as dates, choices, and related data using special queries.

Handling Appointments from the Last Month

Ace begins by showing how to retrieve all appointments from the last month. He explains the challenges of dynamically handling months of different lengths and demonstrates how to use Dataverse queries to get appointments with a scheduled start within the last month.

Using Dataverse Queries

He removes the existing expressions and introduces the Microsoft.dynamics.crm.lastmonth query. By specifying the property name (scheduled start), he retrieves only the appointments from the current month, avoiding data from the previous month.

Exploring Dataverse Filter Criteria

Ace highlights the various Dataverse filter criteria available, such as retrieving data from the last month. He emphasizes that these queries are specific to Dataverse and shares a link to the Microsoft Learn webpage listing all query functions.

Lambda Expressions

Ace introduces lambda expressions, which allow searching on collection values. He demonstrates how to retrieve accounts with emails containing specific keywords and how to use lambda operators to filter data based on relationships.

Using Any and All Operators

He explains the difference between the "any" and "all" operators. The "any" operator checks if any related records meet the criteria, while the "all" operator ensures that all related records meet the criteria. He provides examples of using these operators to filter accounts based on appointment subjects.

Combining Filters and Expand Queries

Ace demonstrates how to combine filters and expand queries to target specific data. He shows how to use the Microsoft.dynamics.crm.thismonth query to retrieve accounts with open appointments within the current month.

Conclusion

In conclusion, Ace highlights the power of Dataverse filter queries and lambda operators in simplifying complex data retrieval tasks. He encourages viewers to explore these features and provides information on virtual mentoring services offered by Pragmatic Works.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power Apps and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.