Tuesday, September 1, 2026

FetchXML

@@'InputSummaryValue:WORKQUEUE': 'Invoice Processing Queue'
WorkQueues.EnqueueWorkQueueItem.WithoutUniqueId WorkQueue: $'''2ff3dc7e-9e73-f111-ab0d-6045bdce39cc''' Status: WorkQueues.WorkQueueItemEnqueueStatus.Queued Priority: WorkQueues.WorkQueueItemPriority.Normal Name: $'''Sample Invoice 001''' Value: $'''{\"InvoiceNumber\":\"INV-1001\",\"AccountName\":\"Contoso Ltd\",\"Amount\":1500}''' ThrowOnDuplicateWorkQueueItem: True WorkQueueItem=> NewWorkQueueItem

@@'InputSummaryValue:WORKQUEUE': 'Invoice Processing Queue'
WorkQueues.EnqueueWorkQueueItem.WithoutUniqueId WorkQueue: $'''2ff3dc7e-9e73-f111-ab0d-6045bdce39cc''' Status: WorkQueues.WorkQueueItemEnqueueStatus.Queued Priority: WorkQueues.WorkQueueItemPriority.Normal Name: $'''Sample Invoice 002''' Value: $'''{\"InvoiceNumber\":\"INV-1002\",\"AccountName\":\"Fabrikam Inc\",\"Amount\":2750}''' ThrowOnDuplicateWorkQueueItem: True WorkQueueItem=> NewWorkQueueItem2

@@'InputSummaryValue:WORKQUEUE': 'Invoice Processing Queue'
WorkQueues.EnqueueWorkQueueItem.WithoutUniqueId WorkQueue: $'''2ff3dc7e-9e73-f111-ab0d-6045bdce39cc''' Status: WorkQueues.WorkQueueItemEnqueueStatus.Queued Priority: WorkQueues.WorkQueueItemPriority.Normal Name: $'''Sample Invoice 003''' Value: $'''{\"InvoiceNumber\":\"INV-1003\",\"AccountName\":\"Adventure Works\",\"Amount\":980}''' ThrowOnDuplicateWorkQueueItem: True WorkQueueItem=> NewWorkQueueItem3

===

DISABLE CALL SeedQueueItems
SET FetchXMLQuery TO $'''<fetch top=\"10\">
  <entity name=\"account\">
    <attribute name=\"name\" />
    <attribute name=\"accountid\" />
    <attribute name=\"revenue\" />
    <attribute name=\"telephone1\" />
    <order attribute=\"name\" descending=\"false\" />
    <filter type=\"and\">
      <condition attribute=\"statecode\" operator=\"eq\" value=\"0\" />
    </filter>
  </entity>
</fetch>'''
@@'InputSummaryValue:WORKQUEUE': 'Invoice Processing Queue'
LOOP WHILE (WorkQueues.ProcessWorkQueueItem.ProcessWorkQueueItem WorkQueue: $'''2ff3dc7e-9e73-f111-ab0d-6045bdce39cc''' WorkQueueItem=> WorkQueueItem)
    SET QueueItemStatus TO $'''Processed'''
    @@organization: '(Current)'
@@entityName: 'Accounts'
@@'OutputSchema:ListRecordsWithOrganizationResponse': '-1746190445'
@@connectionDisplayName: 'Microsoft Dataverse'
External.InvokeCloudConnector Connection: 'd667c13c-7aa3-463e-b905-4bfa087b48d5' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps' OperationId: 'ListRecordsWithOrganization' @organization: $'''current''' @entityName: $'''accounts''' @fetchXml: FetchXMLQuery @ListRecordsWithOrganizationResponse=> ListRecordsWithOrganizationResponse @ListRecordsWithOrganizationHeaders=> ListRecordsWithOrganizationHeaders
    ON ERROR
        SET QueueItemStatus TO $'''Failed'''
    END
    IF QueueItemStatus = $'''Processed''' THEN
        WorkQueues.UpdateWorkQueueItem.UpdateWithProcessingNotes WorkQueueItem: WorkQueueItem Status: WorkQueues.WorkQueueItemStatus.Processed ProcessingResult: $'''FetchXML query executed successfully against Dataverse'''
    ELSE
        WorkQueues.UpdateWorkQueueItem.UpdateWithProcessingNotes WorkQueueItem: WorkQueueItem Status: WorkQueues.WorkQueueItemStatus.GenericException ProcessingResult: $'''FetchXML query failed to execute against Dataverse'''
    END
END

# [ControlRepository][PowerAutomateDesktop]

{
  "ControlRepositorySymbols": [],
  "ImageRepositorySymbol": {
    "Repository": "{\r\n  \"Folders\": [],\r\n  \"Images\": [],\r\n  \"Version\": 1\r\n}",
    "ImportMetadata": {},
    "Name": "imgrepo"
  },
  "ConnectionReferences": [
    {
      "ConnectorId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps",
      "DisplayName": "Microsoft Dataverse",
      "InternalId": "d667c13c-7aa3-463e-b905-4bfa087b48d5",
      "IsDisabled": false,
      "LogicalName": "new_sharedcommondataserviceforapps_e3644",
      "IsEmbedded": false,
      "ConnectionName": "shared-commondataser-49b459e9-3bc7-4b34-a0f2-5ec77c9138ae",
      "ConnectionDisplayName": "Dataverse Connection"
    }
  ]
}

====



Featured Post

FetchXML

@@'InputSummaryValue:WORKQUEUE': 'Invoice Processing Queue' WorkQueues.EnqueueWorkQueueItem.WithoutUniqueId WorkQueue: $...

Popular posts