cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.300 students | PROMOTIONS) : English | Português

View solution in original post

5 REPLIES 5
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.300 students | PROMOTIONS) : 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.300 students | PROMOTIONS) : 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.300 students | PROMOTIONS) : 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
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Virtual Agents Community Super Users!

Congratulations to our Season 1 2021 Super User Crew!

PVA Commnity Blog

NEW Power Virtual Agents Community Blog

View articles posted by fellow community members on the Power Virtual Agents Community Blog!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

Top Solution Authors
Users online (13,315)