Skip to main content

Notifications

Calling Actions from Copilot Studio
Unanswered

PVA saving user outputs as list record

Posted on by 13

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?



 

  • Expiscornovus Profile Picture
    Expiscornovus 29,332 on at
    Re: PVA saving user outputs as list record

    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

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,030

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,085

Leaderboard

Featured topics