Skip to main content

Posts

Featured

Dynamically List Rows From Any Dataverse Table with FetchXML in Power Automate

With the List Rows action of Microsoft Dataverse, we can use FetchXML to query the data. For such queries, all we need is to populate the  Table name and  Fetch Xml Query parameters. But what if we only have the FetchXML? What if we want to query dynamically from different tables based on the FetchXML? One of the use cases would be storing the FetchXML in the config table where the user admin maintains the value and the cloud flow would query the data based on the FetchXML and process the data regardless of which table it is. The solution is to populate the  Table name  parameter of the  List Rows  action dynamically based on the  entity name from the FetchXML. The only problem is that the  entity name  from the FetchXML is the logical name and the  Table name  parameter accepts the EntitySetName (the plural version of the logical name). Luckily, we can easily retrieve the EntitySetName of the table by another  List Rows  action query from the E

Latest posts

Generate Document From Word Template and Send As Email Attachment Using Cloud Flow

Formatting Section or Field Label as Bold/Italic in Model-driven App

Debugging Pre Operation Plug-In Without Plug-In Trace Log

Cloud Flows with Dataverse Trigger Not Working After Solution Import

Image

Error Handling and Show Error Message from API in Canvas App

How to Set Model-driven App Custom Table Icons in Dataverse

Disable Hyperlink for Lookup Columns in Grid Views of Model-driven Apps