Hello community,
I wanted to fetch the latest work queue item from Dataverse that was successfully processed by a particular user, using the "List rows" Dataverse connector.
(Sample record I want to fetch:
)
To achieve this, first I've got the row containing my user details from the "User" table by filtering it based on the "IdentiityId" in List rows action.
Then, I have another used another List rows action to fetch the latest processed work queue item for this user. To do this, I have applied the filters "statecode eq 2 and processinguser eq <user GUID>". Here, statecode=2 is used to check for a processed item, and processing user is being mapped to the GUID that I got from User table.
Then I have sort the result in a descending order based on the "completedon" column (to get the latest processed item).
And mentioned the "Row Count" as 1 (to get only 1 item).
But while running this flow, I'm getting the following error:
"error": {"code": "0x80060888","message": "A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.CRM.systemuser' and 'Edm.Guid' for operator kind 'Equal'."} It appears that since the "processinguser" column in "Work Queue Items" table will ultimately result a Owner type of data, it's not able to match it with a GUID type.But, the Lookup column for "processinguser" is the "systemuserid" column in the "User" table, which is of GUID type, then shouldn't it be able to compare and return me the matching records.How do I go about to get my desired result?
The 2 concerned columns for reference:
