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

PVA insert data in OneDrive excel sheet and then display this data

How i can insert data in OneDrive excel sheet and then display this data from a pva bot

 

Thanks 

3 REPLIES 3
renatoromao
Super User
Super User

Hi @GhassanSd ,

 

Insert data into Excel (OneDrive)

You can use Power Automate action to save rows inside the Excel table using this documentation:

https://docs.microsoft.com/en-us/connectors/excelonline/#actions

 

List rows into PVA

You can use Power Automate action to get rows inside an Excel table using this documentation

https://docs.microsoft.com/en-us/connectors/excelonline/#actions

After it, you can use Markdown to format items inside the Power Automate and send as outputs to show inside the PVA response

https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support#tables

 


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

You can find a video that learn how to in power virtual agent insert data in OneDrive excel sheet and then display this data ?

Unfortunately, not yet.


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

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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.

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Center-of-Excellence-Starter-Kit-cropped 768x460.png

The Total Economic Impact™ of Power Virtual Agents

Read this 2021 commissioned study, conducted by Forrester Consulting.

Top Solution Authors
Users online (1,857)