I need to automate ticket allocation system depending on available resource and resource skill set. Is that possible using PVA
Hi @Yallaling,
Yes, I would think this should be possible. With a PVA you can list items present in a table and filter on the input you got from your PVA.
For example in this thread you see how you can read data from an excel:
https://powerusers.microsoft.com/t5/Building-PVA-chatbots-in/Read-from-Excel-file/m-p/1662697/highlight/true#M820
Let us know how you progress with your setup and if you need any additional help.
We are starting from Scratch.
I am planning like that, PVA will download excel sheet where all ticket information are there and then it will filter open ticket and assign to particular employee deepening on some skill set.
Can you share a bit more details? Do you already have a system which is storing the ticket allocations and the resources and skill sets? Or are you starting from scratch?
And where does the Power Virtual agent/chatbot fit in this scenario? Can people/employees submit a ticket and will the bot try and find the right person to solve it by any chance?
@renatoromao @Expiscornovus , Please help
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Ragavendar Swaminatha Subramanian as our September…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 420 Super User 2025 Season 2
trice602 141 Super User 2025 Season 2
Jerry-IN 68
