Substring to CSV Table to Response in ChatBot Flow

(0) Share

Report

Posted on by ScottinPoland

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:

Power Automate Flows

substring.jpg

All responses (2)

Answers (1)

Verified answer

ScottinPoland 35 on at

Like (0)

Report

Re: Substring to CSV Table to Response in ChatBot Flow

I managed to solve this by doing the following:
Need to have RETURN at the end after : (I have two, otherwise the results are bunched up).

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 35 on at

Like (0)

Report

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?