Microsoft Dynamics 365 | Integration, Dataverse...

How to use Flow to update the Worked By field in the Queue Item entity

(0) Share

Report

Posted on by MikeExeter

Hi Guys

I have a custom field on the Case entity called 'new_workedby'. When I change the user name in this field, I want the Queue Item entity 'Worked By' field to reflect the same value. I've had several stabs at doing this with Flow. My latest attempt is below:

So - when the custom field on the Case is changed:

Get the ID of that Case - in this case I've tried to use the object id of the queue item referring to the Unique Identifier of the Case (in the Row ID field below):

Then finally, update the Queue Item 'Worked by' field to reflect the same user that is in the custom field of the case i.e. new_workedby'

I just cannot get this to work - the latest error being:

'Could not find a property named 'objectid' on type 'Microsoft.Dynamics.CRM.queueitem'.'

But there is a field called objectid on the queue item entity! - So I really don't understand why it's erroring?

Any help how to get this flow working would be greatly appreciated.

Many thanks in advance.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

Get a row by id will fail.

You will have to use list rows action with filter criteria as below

_objectid_value eq Case from dynamic content

Now apply loop and then update a row by id.

Was this reply helpful? Yes No
MikeExeter 54 on at

Like (0)

Report

Hi Bipin

Many thanks for reaching out.

I'm not that versed with Flow - would you mind expanding on that with a screenshot from Flow perhaps? It would help a great deal.

Kind regards

Mike

Was this reply helpful? Yes No
Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Please see below images

Update A Row - /systemusers(select workerid field from dynamic content)

I have exported my flow and uploaded on my GitHub at below location..you can download the zip file and import in your instance if you face any issue while configuring flow based on my images.

File name starts with Updatequeueitem_

github.com/.../Power-Automate-Collections

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Check below article on how to import flow using zip file

powerautomate.microsoft.com/.../

Was this reply helpful? Yes No
MikeExeter 54 on at

Like (0)

Report

Hi Bipin

Many thanks for this! The final step is to clear out the 'worked by' field that was changed in the very first step - what would be the best way to do this - because when I put an expression of 'null' the flow doesn't like it and fails.

Kind regards

Mike

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Please check below article.

www.inogic.com/.../

Unrelate action can also be used

learn.microsoft.com/.../relate-unrelate-rows

Was this reply helpful? Yes No