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

PVA saving user outputs as list record

Hi all,

I'm looking for saome advices about creating ChatBot that will save user inputs as items in SharePoint list.

For example I asked questions for user to provide details like First Name, Last Name, Phone Number etc.

Yarensky_0-1661421555016.png

 

and then after that I added an Power Automate action:

Yarensky_1-1661421677059.png


Main problems are:
How to get rid of "Title" that is mandatory.
What should be addied in Returtn values?

I have a few more details that I have to add to complete full record in SPo list. So should I add Power Automate action after collecting all the answers?



 

1 REPLY 1
Expiscornovus
Super User
Super User

Hi @Yarensky,

 

Title is a system wide field of SharePoint. Probably the easiest solution is just use it and populate it with a value. I would suggest to use a concatenation of the first name and last name.

 

In the return value I would add an output variable with for example the name Result. And as a value I would use "Item has been created in list". You can use that to feed back to the user that the list item creation has succeeded.

 

Below is an example

 

1. The flow setup

 

firstnamelastname.png

 

2. The setup for the topic in the Bot

 

firstnamelastname_topic.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Virtual Agents Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Virtual Agents!

Top Solution Authors
Top Kudoed Authors
Users online (3,927)