SET CRUD_ItemName TO $'''FetchXML CRUD Demo Item'''
@@organization: '(Current)'
@@entityName: 'Work Queue Items'
@@'OutputSchema:ListRecordsWithOrganizationResponse': '200408967'
@@connectionDisplayName: 'Microsoft Dataverse'
External.InvokeCloudConnector Connection: 'd667c13c-7aa3-463e-b905-4bfa087b48d5' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps' OperationId: 'ListRecordsWithOrganization' @organization: $'''current''' @entityName: $'''workqueueitems''' @fetchXml: $'''<fetch top=\"1\"><entity name=\"workqueueitem\"><attribute name=\"workqueueitemid\" /><attribute name=\"name\" /><attribute name=\"statecode\" /><attribute name=\"input\" /><filter type=\"and\"><condition attribute=\"name\" operator=\"eq\" value=\"%CRUD_ItemName%\" /></filter></entity></fetch>''' @ListRecordsWithOrganizationResponse=> SearchResult @ListRecordsWithOrganizationHeaders=> ListRecordsWithOrganizationHeaders
IF IsNotEmpty(SearchResult['value']) THEN
SET FoundItemId TO SearchResult['value'][0]['workqueueitemid']
IF Contains(SearchResult['value'][0]['input'], $'''UpdatedBy''', False) THEN
@@organization: '(Current)'
@@entityName: 'Work Queue Items'
@@connectionDisplayName: 'Microsoft Dataverse'
External.InvokeCloudConnector Connection: 'd667c13c-7aa3-463e-b905-4bfa087b48d5' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps' OperationId: 'DeleteRecordWithOrganization' @organization: $'''current''' @entityName: $'''workqueueitems''' @recordId: FoundItemId
ELSE
@@organization: '(Current)'
@@entityName: 'Work Queue Items'
@@'item/processortype': ''
@@'item/slastatus': ''
@@'item/statecode': ''
@@'item/statuscode': ''
@@'InputSchema:item': '-549033546'
@@'OutputSchema:UpdateRecordWithOrganizationResponse': '901525354'
@@connectionDisplayName: 'Microsoft Dataverse'
External.InvokeCloudConnector Connection: 'd667c13c-7aa3-463e-b905-4bfa087b48d5' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps' OperationId: 'UpdateRecordWithOrganization' @organization: $'''current''' @entityName: $'''workqueueitems''' @recordId: FoundItemId @'item/input': $'''{\"UpdatedBy\":\"FetchXML_CRUD_Demo\",\"UpdateNote\":\"This record was updated via the Upsert (Update) action after being found by FetchXML search\"}''' @UpdateRecordWithOrganizationResponse=> UpdateRecordWithOrganizationResponse2
@@'InputSummaryValue:WORKQUEUE': 'Invoice Processing Queue'
LOOP WHILE (WorkQueues.ProcessWorkQueueItem.ProcessWorkQueueItem WorkQueue: $'''2ff3dc7e-9e73-f111-ab0d-6045bdce39cc''' WorkQueueItem=> WorkQueueItem2)
WorkQueues.UpdateWorkQueueItem.UpdateWithProcessingNotes WorkQueueItem: WorkQueueItem2 Status: WorkQueues.WorkQueueItemStatus.Processed ProcessingResult: $'''FetchXML query executed successfully against Dataverse'''
END
END
ELSE
@@organization: '(Current)'
@@entityName: 'Work Queue Items'
@@'item/processortype': ''
@@'item/slastatus': ''
@@'item/statecode': ''
@@'item/statuscode': ''
@@'InputSchema:item': '1553609861'
@@'OutputSchema:CreateRecordWithOrganizationResponse': '-1235193255'
@@connectionDisplayName: 'Microsoft Dataverse'
External.InvokeCloudConnector Connection: 'd667c13c-7aa3-463e-b905-4bfa087b48d5' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps' OperationId: 'CreateRecordWithOrganization' @organization: $'''current''' @entityName: $'''workqueueitems''' @'item/input': $'''{\"CreatedBy\":\"FetchXML_CRUD_Demo\",\"Note\":\"This record was created via the Add a new row (Create) action because FetchXML search did not find an existing match\"}''' @'item/name': CRUD_ItemName @'item/workqueueid@odata.bind': $'''/workqueues(2ff3dc7e-9e73-f111-ab0d-6045bdce39cc)''' @CreateRecordWithOrganizationResponse=> CreateRecordWithOrganizationResponse
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"
}
]
}
===
@@'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"
}
]
}
====