cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dezjaron
Frequent Visitor

Getting Information form the common data service with power virtual agent

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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/


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

View solution in original post

5 REPLIES 5
renatoromao
Super User
Super User

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/


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

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:

 
 

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/


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

View solution in original post

Hi @Dezjaron ,

 

Did you understand my answer?


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

@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-V...

Helpful resources

Announcements
V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

PVA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors
Users online (1,832)