Unanswered

How to create a list/array of user responses and trigger a flow to save them in Sharepoint list?

(0) Share

Report

Posted on by VS-07011110-0

Hi All!

Power Platform newbie here, trying to work on a requirement:

I am working on a Q&A chatbot in Copilot that dynamically gets questions from Sharepoint list. Basically, in the beginning of conversation, user will select one topic and based on the selected topic, questions will be presented to user. (I have one Sharepoint List where I have listed topic-wise questions). I could get these questions dynamically in Copilot.

Now, I want to do this:

Confirm user inputs for each questions at the end of conversation. For which, I want to create an array-like functionality that stores all user inputs.
Send these answers back to Sharepoint List. i.e. need to trigger a flow from Copilot that saves these data in List.

How can I implement this? I tried creating variables that stores user's answers but it is overlapping and at the end, it just shows me the last record. (I have used patch(), I don't know any other way)

Please someone guide me, how can I save these user's answers to all the questions and save it back to Sharepoint list?

Any guidance or help will be much appreciated!:)

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report
Hi VS-07011110-0,

Instead of using individual variables, you should use a collection or an array-like structure to store user inputs dynamically for each question

At the start of the conversation, initialize an empty array - Set(userResponses, []);

As the user answers each question, append the input to the array along with the associated question. Collect(userResponses, {
Question: CurrentQuestion,
Answer: UserAnswer
});

Once all questions are answered, display the userResponses array to the user for confirmation.

"Here are your responses:
1. [Question 1]: [Answer 1]
2. [Question 2]: [Answer 2]
...
Do you want to submit these responses?"

Use Power Automate to save the collected responses into a SharePoint List.

Trigger Power Automate from Copilot:

Add a step in Copilot to trigger the Power Automate flow using the "Call an Action" Pass the userResponses array as a parameter to the flow.

{
"Responses": [
{
"Question": "What is your name?",
"Answer": "John Doe"
},
{
"Question": "What is your favorite color?",
"Answer": "Blue"
}
]
}

Create the Power Automate Flow:

Use a manual trigger or an HTTP request trigger to accept the userResponses array.

Parse JSON: Parse the input JSON to extract individual responses.

Create Items in SharePoint: Use the "Create Item" action in Power Automate to add each response to the SharePoint List.

pls try - Thanks.

Was this reply helpful? Yes No
VS-07011110-0 on at

Like (0)

Report

Hello @SaiRT14,

Thanks for the suggestion but I believe, we dont have Collect function in Copilot studio. Can you please let me know how to make this possible?

Was this reply helpful? Yes No