web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Getting Information fo...
Copilot Studio
Answered

Getting Information form the common data service with power virtual agent

(1) ShareShare
ReportReport
Posted on by 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?

I have the same question (0)
  • CU22081450-0 Profile Picture
    Most Valuable Professional on at

    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 1Value X
    Field 2Value Y
    Field 3Value 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/

  • Dezjaron Profile Picture
    19 on at

    power automate.jpgThank 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:

     
     
  • Verified answer
    CU22081450-0 Profile Picture
    Most Valuable Professional on at

    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/

  • CU22081450-0 Profile Picture
    Most Valuable Professional on at

    Hi @Dezjaron ,

     

    Did you understand my answer?

  • PS Profile Picture
    27 on at

    @Dezjaron watch this video from 11:20 to 14:00 and use the steps mentioned to get the formatted values.

    https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/Agent-Power-Virtual-Agent-Episode-4-Variables-and-Power-Automate/td-p/554916

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
11manish Profile Picture

11manish 227

#2
sannavajjala87 Profile Picture

sannavajjala87 208 Super User 2026 Season 1

#3
Valantis Profile Picture

Valantis 198

Last 30 days Overall leaderboard