How to update value of work queue item in power automate desktop flow?
Introduction
The recent release of Power Automate Desktop (v2.50) allows updating value of work queue items without changing the status of an item.
Through this tutorial I have explained the process to update the value of ‘Queued’ invoice items with the latest values stored in an input csv file. The value of work queue items is being replaced with JSON object using “๐จ๐ฝ๐ฑ๐ฎ๐๐ฒ ๐๐ผ๐ฟ๐ธ ๐พ๐๐ฒ๐๐ฒ ๐ถ๐๐ฒ๐บ” action.
Scenarios
Following are the possible scenarios of using ‘Update work queue item’ action:
๐ It makes it possible to create a new work item by updating its value (input)
๐ Work item value can be updated without changing its status
๐ We can use a single queue for more than one desktop flows for larger projects by combining with filter work queue items action
๐ Give options to think of work queue as first choice instead of using custom SQL databases
Tutorial
Key takeaways from this tutorial:
โถ๏ธ Use ‘๐๐ฆ๐ต ๐ธ๐ฐ๐ณ๐ฌ ๐ฒ๐ถ๐ฆ๐ถ๐ฆ ๐ช๐ต๐ฆ๐ฎ๐ด ๐ฃ๐บ ๐ง๐ช๐ญ๐ต๐ฆ๐ณ’ action to return specific records by applying filter query
โถ๏ธ Apply query in ‘Filter data table’ action to filter records in data table variable
โถ๏ธ Update value of a work queue item without changing its status
Juliana
What pre configuration I need to do?!
I’m facing this issue when I try to update the work queue item:
“code”: “WorkQueueItemInputUpdateNotAllowed”,
“message”: “Invalid update of attribute input when work queue item is in state Processing. You can allow this operation by updating the ‘allow updating input’ flag at the work queue level.”
but I can’t find this flag in Portal.
Manish Solanki
Apologies for late reply!
To change the input value for processing status, you need to change the value of choice column ‘Allow update item input while in processing.’ from ‘Work Queue’ Dataverse table. The table wouldn’t allow you to change column value directly but you can create an app (Model driven app) on top of ‘Work Queue’ table and modify the choice column for a particular work queue. Try updating the input value post setting the value of ‘Allow update item input while in processing.’ column.
Pls let me know if you still face the same issue.
Thank you!
Bruno
Good Manish,
I’ve had the same problem as Juliana. I tried to create an application (model diver app) but I don’t know what you mean by “on top of work queue table”. I still can’t enable the ‘Allow update item input while in processing’ option.
Could you tell me the steps to create this application and if this would be enough to use the input values โโupdates in my entire Power Automate environment?
Thankssss
Manish Solanki
Hi Bruno,
Please give me 2-3 days. I am planning to write another blog to cover that scenario. We have limitations to attach screenshots while replying to comments or queries.
Thank you!
Manish Solanki
Here is the link that solves this problem:
https://manish-solanki.com/how-to-update-the-value-of-work-queue-item-during-processing/
Manish Solanki
Here is the link of my latest blog that solves this problem:
https://manish-solanki.com/how-to-update-the-value-of-work-queue-item-during-processing/
Bruno
Good Manish,
I’ve had the same problem as Juliana. I tried to create an application (model diver app) but I don’t know what you mean by “on top of work queue table”. I still can’t enable the ‘Allow update item input while in processing’ option.
Could you tell me the steps to create this application and if this would be enough to use the input values โโupdates in my entire Power Automate environment?
Thankssss
Manish Solanki
Here is the link of my latest blog that solves this problem:
https://manish-solanki.com/how-to-update-the-value-of-work-queue-item-during-processing/