Power Automate
Dataflows for Power Apps: calling a table-valued SQL function with Power Query
It’s very easy to query SQL table-valued function to retrieve the result with Dataflows. This is how we do this. Let’s connect to a…
Tag: query
Dynamics 365 Great Plains
SQL Query to Get Login Password Expiry
I don’t recall exactly why this script was required, but the below SQL query can be used to get the expiration date for logins…
Dynamics 365 Great Plains
Microsoft Dynamics GP Analytical Accounting Open Transactions SQL Query
I was looking into a problem reported by a client recently and needed to check the assignment of Analytical Accounting Transaction Dimension Codes to…
Dynamics 365 Customer Engagement
Query Syntax For Relevance Search In Customer Engagement Apps
In November 2020, Microsoft introduced a new and improved Relevance Search experience to customer engagement apps (Dynamics 365 Sales, Customer Service, Field Service, Marketing…
Dynamics 365 Customer Engagement
5000 records limit of Fetch XML Query – List records action of Common Data Service (current environment) connector in Power Automate
Recently in one of our requirements, while trying to fetch contact records using Fetch XML Query https://docs.microsoft.com/en-us/connectors/commondataserviceforapps/#list-records we realized that we can only retrieve…