You’re offline. This is a read only version of the page.
Announcements
I'm just started exploring PA and we wanted to check if it was possible to create an automation which when triggered:
I was able to find a Dataverse activity which dequeues items, but that isn't exactly what I was looking for. I wanted to fetch the workqueue data without changing its status. The end goal is to to perform some analytics with work queues.
There might be a simple solution to this but since I'm new to PA even the simplest of tasks is quite challenging. I'd appreciate your insights on this - thanks in advance!
Hi @AshwinAK
Since workqueue items are stored in Dataverse table Work Queue Items , there is an action List rows which helps to list all rows in that dataverse table. And here you need only specific workqueue's items from that table which you need to filter Workqueue's id.
WorkQueue's id you can get it from the workqueue's page from URL itself
see the yellow highlighted value
Now use that in list rows so that you can filter the table (dataverse) by using that queue ID. see below how i have done-
The output of list rows will only contains the records present in given workqueue which we needed.
Now There is a input dynamic content coming as output which represent the data present in workqueue
Use that value to extract required details which you can sent to Power Bi for data visualization purposes.
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Share
Report
All responses (
Answers (
18,129
