Forum Discussion
Return data from a Power Bi dataset into a power virtual agent via a power automate flow :-)
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
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
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.
5 Replies
- GilbertQ
Super User
Is your column [userId] text or integer. If it is text make sure to encapsulate it with the double quotes "
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.
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
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.
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
