You’re offline. This is a read only version of the page.
19
Hello,
I am trying to use PVA to get a certain field from the CDS. PVA asks the user to input their email, then it calls a flow. When the flow is activated I use the list records action and filter the query by the email. That part works. When I return the value form the list records it returns value that is not readable. I am trying to return a certain value back to the power virtual agent and display the exact information form the field. Is there a certain way I can go by doing that?
@Dezjaron watch this video from 11:20 to 14:00 and use the steps mentioned to get the formatted values.
Great!
Now, I understand your scenario.
So you can create an action inside Power Automate (before Common Data Service action) called Initialize Variable. And select the type "String" and type the name of the variable and the value doesn't need to fill.
After your action called "List records", create a new action called "Apply to each". Select and inside the textbox card insert the "results" or "body" (I don't remember).
Now for each result, your workflow will pass inside this action.
Now, create a new action inside "Apply to each" called "Define variable". Select your variable created and insert the value using your column that you want to show.
And finally, inside your Power Virtual Agents Response action, insert the variable value instead of the "Next link" value.
---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.
Thanks!
Renato Romão
https://www.linkedin.com/in/renatoromao/
Thank you! @renatoromao
I want to return a certain field like their name or other information. When I go to the return value in power automate I only see the next link dynamic content, How can I chose a specific field? Here is what I have so far:
Hi @Dezjaron ,
Congrats, it's a great integration!
Do you want to return more than one field formatted like a table to PVA?
E.g.:
| Field 1 | Value X |
| Field 2 | Value Y |
| Field 3 | Value Z |
- If yes, you can format values using Markdown inside the Power Automate to format items and send the response to the output parameter (string).
https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support#tables
Or do you want to format just one field?
- If yes, can you take some pictures inside your Power Automate to understand the value, format, and fields that you want to show?
---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.
Thanks!
Renato Romão
https://www.linkedin.com/in/renatoromao/
#1
Romain The Low-Code...
132
#2
Michael E. Gernaey
81
Super User 2025 Season 1
#3
Pablo Roldan
61
Share
Report
All responses (
Answers (
