Power Automate SubString only bring back three results

(0) Share

Report

Posted on by ScottinPoland

Hello,

I have a simple call an action in Power Automate. The trigger is user input (word) that I have called Partial Match, I'm using this to Get Items from a SharePoint List. Then I'm creating a CSV Table to bring back the results (all items in the list that contain the work entered). I'm then using this to give a list of possible names in a message with PVA Chatbot flow.

It works, however I'm wondering if there:

1) The is a way to have the results on separate lines. In the PVA test area they are one on top of the other, that looks nice and neat. However when published they are in a line with only a small space between then.

2) Is there a way to return each option as part of a multiple choice question? This would make the flow more automated, but might be beyond my understand / current skills.

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,857 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @ScottinPoland,

I would suggest to have a look at markdown language. That is a great way to adding some formatting.

Btw, you can also try and use a Select action instead of a CSV action. With a join function you can join each item together as a string value with a separator of your choice. Below is an example with a newline character. You might want to replace that with a markdown character/formatting instead.

join(body('Select'), decodeUriComponent('%0A'))

Was this reply helpful? Yes No