web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Share Point Read and U...
Copilot Studio
Unanswered

Share Point Read and Update Data

(0) ShareShare
ReportReport
Posted on by 3,284

Hi there,

 

New to PVA and I have this silly question?

If I have a share point with multiple columns i.e UserName, DeviceID, Location. And my bot user want to know about any equipment status and he only knows the user name. Can this info be retrieved by the bot? and also any updated can be patched to my record from the bot?

 

BTW, the username can be in many devices. 

Categories:
I have the same question (0)
  • Monkeyman Profile Picture
    325 on at

    Yes. You would need to build a power automate cloud flow. Ask the user in the chat bot, what user name they want to look for then pass that value to the cloud flow. 

    get list items in Sharepoint and then pass those values back to power virtual agents topic. 

  • Sajarac Profile Picture
    3,284 on at

    Hey @Monkeyman, thank you very much for your prompt response. I did it and I was able to retrieve the result in my bot. Whoever because I am sending back the result in a HTML table I am getting a messy table with all the <tags> on it.

     

    Do you know how to return the results in a nice format?

     

    the reason why I am asking this is because just in case the result are a a couple of records. I would like those records organized in the chatbot answer.

  • Monkeyman Profile Picture
    325 on at

    Use a create html table step and pass the information in there, then send that result back as the value to PVA.

     

    If I have helped you with this, please mark my first solution as accepted.

     

    Thanks !

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 676

#2
Vish WR Profile Picture

Vish WR 268

#3
Haque Profile Picture

Haque 267

Last 30 days Overall leaderboard