Return data from a Power Bi dataset into a power virtual agent via a power automate flow :-)

[JohanPuttaert]

Hello,

I am trying to start a power automate flow from a power Virtual Agent to recover 2 fields from a power BI dataset.

I managed to get the correct result but I fail to return the values to the virtual agent.

Do you guys have any advice?

Johan

[Anonymous]

Hi Johan,

Can you let know how you had integrated PVA with PBI report, so that the user can interact over PVA.

[Anonymous · Accepted solution]

Hi @JohanPuttaert ,

Refer this document , the Search rows action returns the List of rows variable, which contains JSON data. Before you can use the data, you'll need to analyze it with the Parse JSON action.Please check your result output format.

Please refer to the following document for more information.

Use Power Automate flows in Power Virtual Agents - Power Virtual Agents | Microsoft Learn

Use Power Virtual Agents Connector to build Power Automate flows for your bot | Microsoft Power Virt...

How to call Power Automate Flow from Power Virtual Agent | Softchief Learn

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[JohanPuttaert]

I found the solution anyway, and in the meantime, I got a little smarter by trying.

Thanks in advance for putting me on the right track.

Regards
Johan

[GilbertQ]

Hi @JohanPuttaert 

Is your column [userId] text or integer. If it is text make sure to encapsulate it with the double quotes "

[JohanPuttaert]

Thx for feedback.

It is an integer-value.
But that wasn't immediately the problem. I'm dabbling with sending it back to the virtual agent.