Skip to main content

Notifications

Calling Actions from Copilot Studio
Answered

Substring to CSV Table to Response in ChatBot Flow

Posted on by 35

Hello,

 

I have created a simple Call an Action within a PVA Chatbot flow. It does what I want it to do, which is to take the user input, check a SharePoint List and return all possible answers. However the possible answers are in a line and it isn't clear on on where one ends and the next begins. In the Test Bot area they are stacked one above the other and look nice and neat, however when published they are in a single line.

 

I need advice on:

 

1. Is there a way to better format the return?

2. Next Level would be to have the options as a multiple choice / click option for the user.

Categories:
  • Verified answer
    ScottinPoland Profile Picture
    ScottinPoland 35 on at
    Re: Substring to CSV Table to Response in ChatBot Flow

    I managed to solve this by doing the following:

    ScottinPoland_0-1682342099336.pngScottinPoland_1-1682342163094.pngScottinPoland_2-1682342179688.png

    Need to have RETURN at the end after :  (I have two, otherwise the results are bunched up).

    ScottinPoland_3-1682342233394.png

    ScottinPoland_4-1682342246906.png

     

    Works well, each result is nicely stacked in a column with one above the to other.

     

    Not to see if I can turn the results in a click options for the user 🙂

     

     

     

  • ScottinPoland Profile Picture
    ScottinPoland 35 on at
    Re: Substring to CSV Table to Response in ChatBot Flow

    Looking at the output from the body of the Create CSV table I can see that the partial matches are separated by:

     

    \r\n
     
    Could I use the REPLACE expression? or would I have to use Create HTML Table instead of Create CSV Table?

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,030

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,085

Leaderboard

Featured topics