Unanswered

Copilot Chatbot to provide ticket details as response

(0) Share

Report

Posted on by gopikacos

I'm building a copilot chatbot in copilot studio. in which copilot should provide the ticket details like status, priority etc. as response.The ticket dump (an excel file )with all the data like status, priority etc. is kept in a SharePoint path. User will be providing the ticket number to chatbot. based on the ticket number, chatbot should be able to fetch the details of that specific ticket and provide as a response. the necessary fields out of that ticket dump. I want to retrieve the ticket number, ticket status, and priority information. The Flow under chatbot ought to be able to retrieve the necessary fields for that particular ticket from ticket dump based on the ticket number the user enters. then provide it to the chatbot. Tell me how to construct the flow, please. I have a flow, but it isn't operating as I had anticipated. Please advise what modifications to the flow I need to do in order to meet this need.

My chatbot setup is as below

My action flow is as below.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

theMac on at

Like (0)

Report
Copy link

Link copied!

you need to test it to see if it works and where it can eventualy crash... I had an issue (i.e.) when input parameters wasn't found in excel table so I had to manage the situations (get a Row successful and not)

Was this reply helpful? Yes No
gopikacos 14 on at

Like (0)

Report
Copy link

Link copied!

I have created an office script in excel to fetch the matching output based on the keyword we are entering. The office script is working fine. i'm trying to run the office script in a powerautomate flow with the action "run script from sharepoint library " then pass the output to "Compose" action then finally pass it to "Return value(s) to Power Virtual Agents". Later i'm calling this flow on copilot chatbot. while testing the copilot , after entering the keyword to search, it gives me an error ,
“Error Message: The output parameter with name ‘resolution_note’ on flow ‘Resolution Flow-2’(‘fcccebe9-eeec-ee11-a1fd-000d3a667c69’) is missing from the response data. Please refresh the flow, or ensure the flow returns this value. Error Code: FlowActionException Conversation Id: 28d55858-3e7c-473d-a672-43ec473c68f9 Time (UTC): 2024-03-28T14:04:32.587Z. “
If I check the flow running status, it shows success. And in the flow output I can see it returned the correct output based on the keyword I provided to the chatbot. Please let me know how can I rectify this error in chatbot?
Screenshots of my flow
screenshots of my chatbot configuration

error screenshot from chatbot

Was this reply helpful? Yes No
theMac on at

Like (0)

Report
Copy link

Link copied!

It seems correct to me ... I had to wait a couple of hours after flow modifications to have it working in copilot, may this be your situation?

Was this reply helpful? Yes No
gopikacos 14 on at

Like (0)

Report
Copy link

Link copied!

I've waited for over twenty-four hours, and the problem persists. According to the keyword I entered in the chatbot, my flow is giving the right output. nevertheless the copilot continues to display the same error.

Error:
Error Message: The output parameter with name ‘resolution_note’ on flow ‘Resolution Flow-2’(‘fcccebe9-eeec-ee11-a1fd-000d3a667c69’) is missing from the response data. Please refresh the flow, or ensure the flow returns this value. Error Code: FlowActionException Conversation Id: 4002c401-faa5-458e-b484-817af141a1e6 Time (UTC): 2024-03-29T09:01:07.313Z

Was this reply helpful? Yes No
gopikacos 14 on at

Like (0)

Report
Copy link

Link copied!

Can someone please help me with the above error message

Was this reply helpful? Yes No