You’re offline. This is a read only version of the page.
Hi all,
I'm building a flow coming from an action in Power Virtual Agent that get the data of the customer and display on the chatbot.
The first block is the "Get Row" where I connect to the database, table name and row.
Until that point is fine, so after that I use the "Initialize variable" to store the data and the "Append to string variable".
The latest is not working as the dropdown is blank and I cannot place a name manually. When I click on the arrow down, nothing comes up and I can't fill up the "Name" field.
See screenshot below:
Any help with that would be great.
Also, after that step, how do I get the data from the variable and show it on the chatbot from Power Virtual Agent?
That will also be a great help if someone can do it.
Kind regards,
Fernando
Could you show what exactly doesn't work?
Hi there, I managed to make it work initializing the variable before the server request, adding the compose block and the parse jason block before adding to a string variable and returning that variable to PVA.
It works better with HTTP as I'm doing an api call.
Thank you for all your support.
So when you look at a previous run of the flow what are you seeing as values in the Compose statements in the Apply to each loop? Is it showing Policy numbers? And are they being appended to the string variable?
Hi @Pstork1 ,
What I'm trying to achieve:
I'm creating a flow from Power Virtual Agent for a Insurance company and when the customer place their policy number I want to retrieve the Policy from the sql database with the following details:
Policy Number
Full name
Phone number
Package (insurance package)
After retrieve the data from the sql server, I want to display on the chat bot.
I know that if I can retrieve one single data, the other ones are gonna be easier.
As I'm new to Power Automate, I'm struggling to pass a single data for now hehe.
I had meant to put the Compose inside the same Apply to Each loop as the Append to String, but your current setup should also work. When you look at a previous run how many loops are the Apply to each making? What values are you seeing in the Compose loop? What does the string being returned to PVA contain? What issue are you having?
I'll be happy to help, but your setup looks like it should work.
Hi @Pstork1 ,
I have done it all.
Can't get my head around these blocks.
I could easily do the same process with gulp and an Ajax call to the server, but as I need to connect to PVA, this is my only way to do it and I can't get the value to show on PVA or even the flow to work properly.
Microsoft tutorials are not really helpful and they seemed to think everyone is a developer and knows all the languages, which is why they advertise the PVA for non developers...lol
As soon as I make one value to pass through PVA, I'm happy, so I can make all the data I need to pass through.
This is my latest set up.
As a troubleshooting measure, try adding a compose that contains the value you are appending to the string variable right before you append it inside the loop. Then after a run you'll be able to see what the actual value was that was being appended to the string.
Also, your original screenshot shows a Return value to PVA action, but there is no data in it. Make sure you add the variable to that or it won't return anything. When you get back to the bot you can display the returned value in a message.
That's the point the data is not passing through:
No idea why is not passing through.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
