Power Platform Community Forum Thread Details

Here is my situation. I'm trying to create a chat with qualified colleagues based on user input from interaction with chatbot. My chatbot asks the user a couple of questions, stores the answers as variables, and then calls an action. In this action the variables are passed in, then it queries a table in a spreadsheet for colleagues matching the input criteria and returns their email addresses to the "create a chat in teams" flow. The problem arises that when I do this I get a for each created automatically because there are multiple emails and this creates multiple chats rather than a single group chat which is my goal. If I "compose" the output of email addresses from the excel connector and try to pass them in as a single variable from there I get the following error: "

Request to XRM API failed with error: 'Message: Flow client error returned with status code "BadRequest" and details "{"error":{"code":"InvalidOpenApiFlow","message":"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Create_a_chat' at line '1 and column '3558' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Create_a_chat' to be referenced by 'repeatItems' or 'items' functions.'.'."}}". Code: 0x80060467 InnerError: '.

I know when I manually put in multiple email addresses in the "create a chat" flow I'm able to generate a single group chat so why can't it function the same way when passing multiple addresses in from the excel query?

I've searched for a way to concatenate the email addresses with ";" or to have them stored as an array variable but to no avail. No matter what, I get a for each and have to either deal with multiple chats or a failed flow. Multiple chats will not work for my use case. This will cause the plug to be pulled on my project so I can't just "deal" with the inconvenience of it unfortunately.

In closing: Is there a way to get email addresses returned from my excel query to act as acceptable inputs for the "create a chat" flow without it generating multiple chats?